forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: photoelaine on October 21, 2003, 04:15:17 am

Title: coppermine installation problem with mysql
Post by: photoelaine on October 21, 2003, 04:15:17 am: I had a previous version of coppermine which i uninstalled. I formatted my system and did a fresh install of my server. When i tried to install coppermine, it gave me this error:

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Can't connect to MySQL server on 'localhost' (10061)

any ideas on how to solve this?

tech spec:
apache 2.0.47
mysql 4.0.15
php 4.3.3
winxp pro

thanks
Title: coppermine installation problem with mysql
Post by: hyperion on October 21, 2003, 04:34:46 am: Is this a testing environment or a production environment?
Title: coppermine installation problem with mysql
Post by: kegobeer on October 21, 2003, 04:38:49 am: Try here: http://forums.devshed.com/t26423/s.html
and here: http://www.webmasterworld.com/forum88/1845.htm
Title: coppermine installation problem with mysql
Post by: photoelaine on October 21, 2003, 07:04:43 am: testing... it is just for a personal site

and i don't know any programming language. :(
read read read... :cry:
Title: coppermine installation problem with mysql
Post by: hyperion on October 21, 2003, 08:18:03 pm: If it is for testing, replace local host with the actual name of the MySQL server (Click on the traffic light, and you'll see it listed to the left.) Then enter the the username listed there as well. If you gave that user name a password, provide that password. You should be able to do this without resinstalling by opening up the include directoty and editing the config file.

Youu will not be able to run Coppermine while the test box is connected to the internet, as it will look for the servername instead of realizing that iit is the local host.

-Hyperion
Title: coppermine installation problem with mysql
Post by: photoelaine on October 22, 2003, 05:34:32 am: how do i get mysql to run? in the previous posts, i went to the links kegobeer suggested. however, after i downloaded the lastest version of mysql and installed it, i don't have an executable to run the actual mysql program. it worked fine before (without having to run the executable). is there a hidden trick?
Title: coppermine installation problem with mysql
Post by: DJMaze on October 22, 2003, 06:03:14 am: Somehow the MySQL won't install the file into "Services" i also have that problem with latest MySQL.

Solution:
Add "C:\mysql\bin\mysqld-nt.exe" to your scheduled tasks and set it up to run when computer starts.

# Click the Start button, select Settings then Control Panel to open the Control Panel window.
# In the Control Panel window, double-click Scheduled Tasks.
# In the Scheduled Tasks window, double-click Add Scheduled Task.
# On the welcome screen of the Scheduled Task Wizard, click Next.
# At the program selection step, click Browse... and browse to your MySQL\Data directory.
# Type MYSQLD-NT.EXE in the File name: edit box or locate it in the directory and select it and click Open.
# Make up a name for this task and under Perform this task: select When my computer starts. Click Next.
# Enter your password. Note: The task must be run under the same account which the dial-up entry was created under.
# At the final step click Finish
Title: coppermine installation problem with mysql
Post by: hyperion on October 22, 2003, 06:04:52 am: Did you tell it to run as a service when you went through the installation?
(Look for a traffic signal icon in the system tray - that will tell you it is running. )
Title: coppermine installation problem with mysql
Post by: photoelaine on October 22, 2003, 06:17:07 am: i finally got mysql to work... :lol:
i'm so stupid... :oops:

thanks for the help!