mysql：is not allowed to connect to this MySQL server解决

此报错由于客户端没有远程连接权限
解决方案：

user mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED  BY '密码' WITH GRANT OPTION;
flush privileges;