执行下面的命令MySQL8会报错：
grant all privileges on db_name.* to 'root'@'%' ### Cause: java.sql.SQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'db_name'
解决办法：
SELECT `User`, `Grant_priv` FROM `mysql`.`user` WHERE `User` = 'root'; UPDATE `mysql`.`user` SET `Grant_priv` = 'Y' WHERE `User` = 'root'; grant all privileges on *.* to 'root'@'%'; FLUSH PRIVILEGES;
MySQL8的root远程授权
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码'; GRANT ALL ON *.* TO 'root'@'%'; FLUSH PRIVILEGES;
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。