- 积分
- 66
- UID
- 18694
- 阅读权限
- 20
- 注册时间
- 2015-5-21
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
我使用root账号登陆mysql,想赋予用户sonar对数据库sonar4的所有权限,执行下面的语句:
mysql> GRANT ALL ON sonar4.* TO 'sonar'@'%' IDENTIFIED BY 'root';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'sonar4'
我检查了root的可用权限:
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, A
LTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*DDCCB6A294E732CF95FD4D194C525DB4775FEFDF' WITH GRANT OPTION |
看着是有grant权限的,不知道是为什么,请大神进来看看 |
|