数据库连接报错is not allowed to connect to this mysql server-解决方案

终端连接数据库（以root账号登陆）

mysql -u root -p

输入命令（我这里账号密码为shop2密码为shop2，要替换为你自己的账号密码）

GRANT ALL PRIVILEGES ON *.* TO 'shop2'@'%' IDENTIFIED BY 'shop2' WITH GRANT OPTION; FLUSH PRIVILEGES;