无法连接到远程MySQL服务器,解决方法:
步骤一:创建远程连接用户
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
步骤二:设置权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
步骤三:刷新MySQL的系统权限相关表
FLUSH PRIVILEGES;
无法连接到远程MySQL服务器,解决方法:
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;