coppermine installation problem with mysql

[photoelaine]

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

[hyperion]

Is this a testing environment or a production environment?

[kegobeer]

Try here: http://forums.devshed.com/t26423/s.html
and here: http://www.webmasterworld.com/forum88/1845.htm

[photoelaine]

testing... it is just for a personal site

and i don't know any programming language.  
read read read... :cry:

[hyperion]

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

[photoelaine]

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?

[DJMaze]

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

[hyperion]

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. )

[photoelaine]

i finally got mysql to work...  :lol:
i'm so stupid...  :oops:

thanks for the help!