我无法在mySQL中创建新模式被拒绝访问。我不是root,所以我需要要求更多的特权,我不确定我应该要求什么。
显示"saher"@"localhost"的资助;
+--------------------------------------------------------------------------------------------------------------+
| Grants for saher@localhost |
+--------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'saher'@'localhost' IDENTIFIED BY PASSWORD '*2472DEC52D39F7EBB1C860FF69436F8E08540F9A' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> 创建模式洪流抓取;
错误 1044 (42000):用户"saher"@"localhost"对数据库"torrentScrape"的访问被拒绝
我可以告诉root执行以下操作吗? GRANT ALL PRIVILEGES ON *.* TO 'saher'@'%' WITH GRANT OPTION;
您需要 CREATE 权限。请注意,CREATE SCHEMA 是 CREATE DATABASE 的同义词。
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_create