If you forget the MySQL root password, you can reset it in the following ways:
1. Kill off the MySQL process in the system;
2. Use the following command to start MySQL, to do not check the permissions of the way to start;
Mysqld_safe-skip-grant-tables &
3. Then use the null password method to log in to MySQL with root user;
Mysql-u Root
4. Change the password of root user;
mysql> Update Mysql.user Set Password=password (' New password ') where user= ' root ';
mysql> flush Privileges;
Mysql> quit
5. Restart MySQL, you can log in with the new password.
Can ' t connect to the MySQL server on ' localhost ' (10061) solution,
1 first check that the MySQL service does not start if it is not started, start the service.
2 Solutions:
The first step is to delete the my.ini below c:windowns
Step two, open C:mysqlbinwinmysqladmin.exe enter username and password
The third step in the DOS input mysqld-nt-remove Delete service, in the next input Mysqld-nt-install
Step Fourth enter MySQL to start successfully.
3 Other methods to refer to:
1. Look at the Hosts file localhost is not pointing 127.0.0.1
2. If the MySQL service is not started, you can run net start MySQL.
3. Some related orders:
Mysqld-nt--install #启动Mysql
MySQL #运行Mysql
Mysql-h Ipaddress-u Username-p
Or: Directly to the bin point Mysqld.exe or Mysqld-nt.exe, see if its process can run normally, if not, then to Control Panel, service to start it, see what is wrong. If not, in addition to delete the deletion of MySQL, and then reload MySQL, generally can solve the problem, you can back up the data before installation.
4 cannot connect to the MySQL server, as possible:
1, the MySQL service does not start, generally in the case of the exception of MySQL can not start, such as no available disk space, My.ini mysql basedir path set error, etc.
2, the MySQL server resource is tight, causes cannot connect.
Workaround:
1, if you are a virtual host user (buy space), then contact space to check whether MySQL normal startup, and confirm MySQL configuration information (whether for localhost);
2, if you are a stand-alone host user (with administrative host permissions), then follow the steps below to check:
1 Check disk space for remaining free space and try to keep enough disk space available.
2 Check the My.ini basedir (MySQL installation address) and DataDir (data directory storage address) and other parameters set is correct, and then restart the MySQL service.
Another way is to put the server's Windows patches.
Microsoft September 9 released the TCP/IP update patch (KB967723), if the server turned on Automatic Updates or have automatic Update software download updated this patch, then this problem will occur.
One might ask, why does the patch 9th appear, only to find the problem now?
As we all know, the server is not restarted every day, some servers may be one months or Yinianbanzai reboot once, and some may be restarted after September 9 server, so the patch is effective (I personally think so).
Patch Uninstall Method: Login to the server, access to the Control Panel---Add and Remove Programs-(check above "Show updates")
In the inside can see the updated KB967723 this patch, and then want to uninstall ordinary software like uninstall, uninstall will prompt you, if uninstall may cause the program to run error, it does not matter, choose "yes", continue to uninstall.
Uninstall completes after the program server, everything is OK!
As for the patch to repair what vulnerabilities, uninstall will appear after the server security risks, this is not to say, to MySQL normal operation, the temporary solution is the only way.