Remember that because there is no network, the Rootpassword changed the wrong to write:
Update user set password= "122" where user= "root";
After that, MySQL started to work.
#mysql-U root-p
#123
will appear: Error 1045 (28000): Access denied for user ' @ ' localhost ' (using Password:no)
It can only do this:
#mysql-U Root
mysql> use MySQL
There's another error 1045 (28000): Access denied for user ' @ ' localhost ' (using Password:no)
Find a long time information:
Workaround:
1. Turn off MySQL
# Service Mysqld Stop
2. Blocking permissions
# Mysqld_safe--skip-grant-table
Screen appears: Starting demo from .....
3. Start a new terminal input
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
Mysql> FLUSH privileges;//Remember to make this remark, otherwise assume to close the previous terminal. And it's going to be the same mistake.
Mysql> \q
That's good.
MySQL prompts access denied for user & #39;& #39;@& #39;localhost& #39; " The solution