Recently started to learn PHP, installed the WAMP integration environment, MySQL can be opened with phpMyAdmin, but want to use the MySQL console but error: MySQL service cannot start (2003-can ' t connect to MySQL server on ' localhost ' (10061).
Many methods of searching the Internet include:
1. Re-install MySQL service
Mysqld-remove MySQL
Mysqld-install MySQL
net start MySQL service starts but the console still fails to start.
It is not possible to point host to 1270.0.1.
2, see a netizen to provide:
If "Error 2003:can ' t connect to MySQL server on ' localhost ' (10061)" appears, your MySQL has not started yet.
Workaround:
The first step
Remove the My.ini below c:\windowns
Step Two
Open C:\mysql\bin\winmysqladmin.exe Enter user name and password
Step three Enter Mysqld-nt-remove Delete service under DOS
In the next input Mysqld-nt-install
Fourth step input MySQL boot success
Results after the deletion of My.ini, did not find Winmysqladmin.exe, run the next Mysqladmin.exe, the window flashed over, also did not see the user name and password. After DOS ran the MySQL command, incredibly can. It seems to be the reason to delete My.ini, it is estimated that the file before the configuration is wrong. First Use the ~
The MySQL service has been started, but the report 2003-----has been resolved