how to start mysql server on windows xp

Question

Whenever I try to start MySQL by typing

> mysql -u root

I get the error

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

How can I solve the problem above? I just downloaded MySQL and unzipped it in the E: drive. I have not done anything else. Do I have to make a connection first? If so, how can I do that?

Answer 1

To  start Mysql Manually from the command line follow the steps and command stated below:

Open window console-> executes the  following command:

shell> "C:\path\MySQL\MySQL Server 5.0\bin\mysqld"

The path can be according to your system.

Have Mysql server right there, If you still find an error to start kindly check the error log to look up the files .err extension find the reason, and troubleshoot it.

And if you want to stop the Mysql kindly execute the below command:

 shell> "C:\Path\MySQL\MySQL Server 5.0\bin\mysqladmin" -u root shutdown.

Enroll in our Online SQL Certification to learn the basic concepts of Microsoft SQL Server.