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

mysql database database-connection mysql-5.1
TomJ picture TomJ · Mar 11, 2014 · Viewed 17.4k times · Source

Please don't post this question as duplicate. I am trying to configure mysql for about 3 weeks now. Someone should really help me.

I recently installed MySQL 5.1 in a Lenovo laptop to do my project. The laptop is running on Windows 8. The installation was fine but when I tried to configure MySQL it worked till the last page.

There am getting Error Nr 2003.

I tried it through the command prompt, through services in the control panel. But the problem is that the mysql service is not starting at all. Why it is not starting ? What will be blocking it from starting ?

Answer

ShinnedHawks picture ShinnedHawks · Dec 17, 2014

First you need to start mysql service it is the problem for this above error.

In case you cant start mysql service means you need to install mysql service.

Steps for install mysql service

Step 1: open command prompt and go to the mysql installed location (for example c:\Program Fiels\MYSQL\Mysql Server5.0\bin\)

Step 2: mysql --install

Step 3: start mysql service using the command NET START MYSQL command

then connect mysql using username and password.

Related questions

MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More
How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
mysql server port number

I've just made a database on mysql on my server. I want to connect to this via my website using php. This is the contents of my connections file: $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $…

Read More