问题1:
问题描述:
解决方法:设置防火墙的入站规则,允许3306连接
问题2
问题描述:
解决办法:
1.授权法
执行如下语句,然后重启mysql服务
GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@'%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION;
例如:
GRANT ALL PRIVILEGES ON *.* TO ‘root’@'%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;