Issue one: MySQL user login without authentication password (user has set password)
After the installation of MySQL, I found that I set up a password, the same can be used without a password to login
Cmd>mysql
Cmd>select Current_User ();
@localhost
Cmd>exit
Cmd>mysql-uroot
Mysql>use MySQL
Mysql>select user, host,password from user;
Show my root account has set a password, the Internet to find the answer that because there are anonymous users, so do not have to verify to log in. The result of the query is an anonymous user.
So delete it.
Mysql>delete from user where user= ';
Mysql>flush privileges; Don't miss out.
Re-login is to verify that it solves a problem, but there is a second problem:
Question two:
ERROR 1130 msyql 1130 MySQL localhost is not allowed
Problem Description: Online search, there is a saying is local no localhost this user, I went back to see the next but is not only root
So according to what you're saying. Enter Sqld Skip-grant-tables in the named row but I tried, this method doesn't solve the problem (again, if the root user is mistakenly deleted)
So, the most helpless but the most effective way is to ———— reload!!!
It's really quick to pack one ...
If there is a 1130 problem solved by Daniel, please share it.