Mysql：access denied for user roo

2020-05-23 本文已影响0人程序员小杰

image.png

登录mysql
root@48e34f384559:/var/lib/mysql# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.

然后执行

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

FLUSH PRIVILEGES;

image.png