我无法在MySQL中创建新的模式,因为我遇到了访问被拒绝的问题。由于我不是管理员,所以我需要请求更高的权限,但我不确定应该请求什么样的权限。
SHOW GRANTS FOR 'saher'@'localhost';
+--------------------------------------------------------------------------------------------------------------+
| Grants for saher@localhost |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'saher'@'localhost' IDENTIFIED BY PASSWORD '*2472DEC52D39F7EBB1C860FF69436F8E08540F9A' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> 创建数据库 torrentScrape;
错误 1044 (42000): 用户 'saher'@'localhost' 没有访问数据库'torrentScrape'的权限
我能告诉管理员做以下操作吗?
GRANT ALL PRIVILEGES ON *.* TO 'saher'@'%' WITH GRANT OPTION;