1. 修改配置(这一步很多教程上没有写,这是最重要的一步)
cd /etc/mysql/mysql.conf.d
vim mysqld.cnf
# 找到#bind-address = 127.0.0.1 ,注释掉,替换成下面的配置
bind-address = 0.0.0.0
2. 重启mysql 服务
service mysql restart
创建用户,授权,刷新配置生效
create user 'demo'@'%' identified by '111111';
grant all privileges on *.* to 'demo'@'%' with grant option;
flush privileges;
mysql -h192.168.xx.xx -P3306 -udemo -p111111