打开一个ssh连接,登录到mysql数据库
直接用命令mysql,进入数据库
修改mysql.user表
use mysql;
delete from user;
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections, plugin, authentication_string) VALUES
("%",“root”,"",“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,"","","","",0,0,0,0,"",""),
(“localhost”,"","",“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,“Y”,"","","","",0,0,0,0,"","");
4.重启mysql: service mysql restart
启动后登录mysql数据库,可以正常看到所有的数据库了。
可能会出现数据库远程连接出现Host is not allowed to connect to this MySQL server解决方法请看下面这篇文章
数据库远程连接出现Host is not allowed to connect to this MySQL server解决方法