MYSQL远程连接被拒绝 Access denied for user ‘root‘@‘****‘ (using password: YES)

错误

java.sql.SQLException: Access denied for user 'root'@'****' (using password: YES)

执行命令

-- 赋权，用户名：root,密码：root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
-- 刷新权限
flush privileges;