MySQL logon and mysql Logon
1. Question 1: You cannot log on after changing the password using update mysql. user set password = 'root'
Solution: perform the following steps.
(1) Close mysql (kill the mysqld process) and run the following command:
Mysqld -- skip-grant-tables
(2) Start the database and the database can be connected normally.
(3) Then clear the root password:
Update mysql. user set password = null
(4) use commandsMysqldStart Database
After completing these steps, you can log on normally.
2. Question 2: MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
Solution:Use Authorization statement authorization
Grant all privileges on *. * TO 'root' @ '%' identified by '000000' with grant option;
Grant root local access permissions.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.