Error connection to MySql locally?

[kefi2927]

Hi

I've installed; php5.0.1 -installer, MySql, MySql Control Center, My_ODBC_ Standard_3519_Win on my WinXP PC.

I cannot seem to connect to the root of MySQL through the MySql Control Center.

The error message I'm getting is:

[root@localhost:3306] ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

I'm a newbie to PHP. If anyone can help me or point me in the right direction it would be very much appreciated.

Cheers

 

[Bastien]

Have you started the the mysql service?

Right click on the 'My Computer' incon, choose manage,
choose 'Services and applications'
choose services
scroll to mysql
right click and choose 'properties'
set the start up type to automatic

hth

Bastien

Cat, the other other white meat

 

[kefi2927]

I tried that and it is not listed?

MySql is definitely installed. When I go to 'Add Remove Programs' it is listed there. Also a directory called 'mysql' has been put on to my C drive?!

Any ideas?

Cheers

 

[ingresman]

Can you connect from the command line ?

 

[kefi2927]

How do I do that? And what do I type into it?

 

[ingresman]

Start up a cmd session (i.e. start->run->cmd) and type mysql. If nothing happens or you get an error you havn't got the directory on the path which mnay be your problem.
Anyhow, assume your have installed into c:\mysql Cd to c:\mysql\bin and then type mysql, you should get the mysql command line intercae up (type \q) to get out.
If you need to get it onto the path go into control panel,then systen choose the advanced tab and click the environment variables button and amend the path environment varaible as required. Reboot the PC just to get all the paths sorted and you may be ok.
I think that just because the service is runniung you still need the library code on the path to connect to it.

 

[kefi2927]

Started up cmd session and CD to c:\mysql\bin and then typed mysql. Original error came up:

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

.

What do you mean by: amend the path environment varaible as required.

Cheers

 

[sleipnir214]

From the command prompt, it will be:

[tt]mysqld[/tt]

rather than

[tt]mysql[/tt]

won't it?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[ingresman]

On the path means that the library the code is installed in must be in an environment variable called path.
Do you have much experience of windows ?
Did you just mysql or did you type anyhting after it ?
The 10061 error (winsock) implies the port that mysql listens to is closed. I belive the default port is 3306. Can you type netstat at the cmd prompt please and look for localhost:3306 in the foreign address column

 

[ingresman]

I think mysqld to start up the server , but I;m trying to see if he can get any kind of client to connect.
opps just reread the post:
try

net start mysql

at the command prompt

 

[ingresman]

in fact, just stoped my service and i get the 10061 error