Mysql 远程连接服务器

#授权外部访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

 

#清空mysql缓存

flush privileges

 

 

通过命令行模式来访问远程服务器

#远程连接mysql

mysql -h 192.168.31.23 -P 3306 -u root –proot