当前位置:Gxlcms > 数据库问题 > 解决Mysql ERROR 1045 (28000)“Access denied for user 'root'@'localhost'”

解决Mysql ERROR 1045 (28000)“Access denied for user 'root'@'localhost'”

时间:2021-07-01 10:21:17 帮助过:34人阅读

    mysql> show grants for ‘episode‘@‘%‘;

2.为用户添加某个数据库的权限:

 mysql> GRANT ALL PRIVILEGES ON `episode_cc`.* TO ‘episode‘@‘%‘ WITH GRANT OPTION;

如果是给所有数据库的权限,则是:
mysql>GRANT ALL PRIVILEGES ON *.* TO ‘episode‘@‘%‘ WITH GRANT OPTION;


解决Mysql ERROR 1045 (28000)“Access denied for user 'root'@'localhost'”

标签:mysql grant 权限

人气教程排行