解决方案一:
1.
#修改权限
$:mysql -u root -p
mysql>use mysql;
mysql>grant all privileges on *.* to 'root'@'%' identified by 'youpassword' with grant option;
mysql>flush privileges;
- 1
- 2
- 3
- 4
- 5
- 6
解决方案二:
2、修改/etc/mysql/my.cnf
找到bind-address = 127.0.0.1这一行
改为bind-address = 0.0.0.0即可
如果还不行的话,修改:
max_connections = 100
最大连接数,重启mysql
service mysql restart