Installing MySQL on Local XP

Anon

I want to setup my Local computer to run MySQL and PHP so I can do local testing before putting my files up on the web.

I downloaded the MySQL with cgi that does the automatic install.

Everything seemed to install fine, except it told me I was not able to use localhost to connect.

It said I would have to reconfigure this manually. Now when I try to do anything with MySOL, it gives me the following error:

connect to server at 'localhost' failed. ' Can't connect to MySQL server on 'localhost' <10061>' Check that mysqld is running on localhost and that the port is 3306.

Can anyone help?

Anon

Did you install MySQL as a service?

Anon

did you try running mysqld-nt.exe?

that should do the trick.

Anon

I ran mysqld-nt, and things seem to be working better. But it's telling me that the server isn't running.

How do I start my computer to act as the server?

Anon

Go into Control Panel > Administrative Tools > Services

Look in that list for MySQL see if it says "started" under the status column. If it does than, well, it's running. Make sure to set it to automatic to load it up on windows start every time.

This is only possible if you have already installed MySQL as a service. So, if you haven't done that yet do this.

Start > Run > cmd

When the command prompt window opens type in.

C:\mysql_directory\bin\mysqld-nt --install

Make sure to point "mysql_directory" to where mysql was installed. That should autmatically set it to run automatically. Now MySQL can be easily started by:

run > Net Start MySQL

or to stop it

run > Net Stop MySQL

Anon

I tried to install the service and it told me this task had already been compleated, but when I try to start MySQL, it gives me this error: "Could not start the MySql service on Local Computer.

Error 2: The system cannot find the file specified"

Currently, mysql is installed in C:\mysql\, is that correct?

Thanks for all the help.

Anon

You checked this right:

Go into Control Panel > Administrative Tools > Services

Look in that list for MySQL see if it says "started" under the status column.

The steps I took to install MySQL was install the executable, then installed it as a service, then I went through the manual to set my root account up. Below is a portion of what the MySQL manual states:

You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password:

C:> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:> C:\mysql\bin\mysqladmin reload
C:> C:\mysql\bin\mysqladmin -u root password your_password

I think that's pretty much all I did to install MySQL.

If all this doesn't help go into C:\mysql\Docs\manual_toc.html

scroll down to where it says

2.1.2 Installing MySQL on Windows

Hopefully that will help you if all else fails.