mariadb本地连接正常,远程连接时提示:Accesss denied for user 'root'@'ip'(using password:YES)
原因:可能是未开通远程连接权限
解决:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
mariadb本地连接正常,远程连接时提示:Accesss denied for user 'root'@'ip'(using password:YES)
原因:可能是未开通远程连接权限
解决:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;