0 votes
1 view
in SQL by (3.3k points)

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?

1 Answer

0 votes
by (6.8k points)

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.

Related questions

0 votes
1 answer
asked Feb 12 in SQL by adhiraj (3.3k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 15, 2020 in SQL by Appu (6.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !