MySQL的远程连接配置

1：修改配置文件/etc/mysql/my.cnf
注释bind-address=127.0.0.1

2：进入数据库
mysql -u root -p

show databases;
use mysql;

3：更新权限

select Host,User from user;
update user set Host="%" where User='root';
flush privileges;
exit;


4：重启数据库服务
sudo service mysql restart;

mysql -h ip/hostname -u root -p
访问远程数据库