linux服务器安装Mysql后，只能看到information_schema/test这两个库

打开一个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解决方法请看下面这篇文章