Solution 1:
Open Task Manager-service-mysql** to see if its status has started, such as not started, right after the start, re-open the MySQL command line Client, restart MySQL.
Solution 2:
The host file (the host file in the C:/WINDOWS/SYSTEM32/DRIVERS/ETC directory) is added
127.0.0.1 localhost
Open My.ini, add in [mysqld]
Bind-address = 127.0.0.1
Restart MySQL
Solution 3:
1. Modify the installation directory of the My.ini file, modify the following methods:
[Mysqld]
Basedir=c:/program Files/mysql/mysql Server 5.1
Datadir=c:/programdata/mysql/mysql Server 5.1/data (that is, the MySQL installation directory, I need to remind that my MySQL is installed in the C disk, After loading the data folder is in the Programdata directory, and Programdata this folder is hidden. On the other plate, I think this data should not be hidden. )
Default-character-server= GBK (or gb2312)
[Winmysqladmin]
Server=c:/program Files/mysql/mysql Server 5.1/bin/mysqld-nt.exe
But after I had modified the method above, the problem was not resolved.
Resolution 4: Modify MySQL is required to have MySQL root permissions, so the general user can not change the password
, unless the administrator is requested.
Use the Set PASSWORD statement,
Mysql> set PASSWORD for "= PASSWORD (' biscuit ');
You must also use the password () function,
but you do not need to use flush privileges.