1、增加访问权限
mysql -u root -p
切换数据
mysql> use mysql;
mysql> select * from user;
mysql> GRANT ALL PRIVILEGES ON *.* TO '账号名称'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES; //刷新权限
如果还不行,继续
2、查看监听地址
lsof -i:3306
监听的localhost,需要修改ip为:0.0.0.0
bind-address=0.0.0.0
注意:默认文件配置在(/etc/mysql/mysql.conf.d/mysqld.cnf)