错误1044 (42000)：拒绝用户访问

Question

我在MySQL中使用密码创建了一个新用户。

mysql> GRANT ALL PRIVILEGES ON simple_cms_development.*
    -> TO 'simple_cms'@'localhost'
    -> IDENTIFIED BY 'xxxxxxx';
Query OK, 0 rows affected (0.04 sec)

我检查它是不是创建的：

mysql> SHOW GRANTS FOR 'simple_cms'@'localhost';
+-------------------------------------------------------------------------------------------------------------------+
| Grants for simple_cms@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'simple_cms'@'localhost' IDENTIFIED BY PASSWORD '*CA931C969BFB20B345B153F9AE0B3EBC543B48EF' |
| GRANT ALL PRIVILEGES ON `simple_cms_development`.* TO 'simple_cms'@'localhost'                                    |
+-------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

我尝试以该用户身份登录，但收到1044错误：

 Macintosh-2:simple_cms kmcrayton7$ mysql -u simple_cms -p simple_csm_development;
    Enter password: 
    ERROR 1044 (42000): Access denied for user 'simple_cms'@'localhost' to database 'simple_csm_development'

按照answer #1 and #6中的步骤进行操作，结果如下：

mysql> select user,host,password from mysql.user;
+------------+-----------+-------------------------------------------+
| user       | host      | password                                  |
+------------+-----------+-------------------------------------------+
| root       | localhost | *986BD1453A6B2F3CCF85DC695B981EE516B7613D |
| root       | macintosh | *986BD1453A6B2F3CCF85DC695B981EE516B7613D |
| root       | 127.0.0.1 | *986BD1453A6B2F3CCF85DC695B981EE516B7613D |
| root       | ::1       | *986BD1453A6B2F3CCF85DC695B981EE516B7613D |
|            | localhost |                                           |
|            | macintosh |                                           |
| simple_csm | localhost | *CA931C969BFB20B345B153F9AE0B3EBC543B48EF |
| simple_cms | localhost | *CA931C969BFB20B345B153F9AE0B3EBC543B48EF |
+------------+-----------+-------------------------------------------+
8 rows in set (0.04 sec)

mysql> exit
Bye
Macintosh-2:simple_cms kmcrayton7$ mysql -u simple_cms -p simple_csm_development;
Enter password: 
ERROR 1044 (42000): Access denied for user 'simple_cms'@'localhost' to database 'simple_csm_development'


  [1]: https://stackoverflow.com/questions/489119/mysql-error-1045-access-denied

我不知道我在哪里犯了错

我正在尝试遵循下面的建议，但现在我似乎根本无法访问：

Macintosh-2:simple_cms kmcrayton7$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Macintosh-2:simple_cms kmcrayton7$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Macintosh-2:simple_cms kmcrayton7$ 

Answer 1

我也遇到了同样的问题，它用以下方法解决了：

GRANT ALL PRIVILEGES ON DBName.* TO 'UserName'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Answer 2

您的用户没有访问simple_csm_development.数据库的权限您需要使用grant语法授予权限：

GRANT priv_type (column_list)，priv_type (column_list)] ...ON object_type priv_level TO user_specification，user_specification ...需要{NONE | ssl_option [[AND] ssl_option] ...}

将user_specification上的代理授予user_specification、user_specification ...带GRANT选项

表：{object_type| FUNCTION | PROCEDURE }

priv_level：{*|。| db_name.* | db_name.tbl_name | tbl_name | db_name.routine_name }

user_specification:用户auth_option

auth_option：{#用'auth_string‘标识的MySQL 5.7.6之前|用密码'hash_string’标识|用auth_plugin标识|用auth_plugin标识为'hash_string‘}

auth_option：{#从MySQL 5.7.6开始，标识为'auth_string‘|标识为密码'hash_string’|标识为auth_plugin |标识为auth_plugin，标识为'auth_string‘|标识为auth_plugin为'hash_string’}

resource_option：{| MAX_QUERIES_PER_HOUR计数| MAX_UPDATES_PER_HOUR计数| MAX_CONNECTIONS_PER_HOUR计数| MAX_USER_CONNECTIONS计数}

Source。

Answer 3

老实说，我不知道是什么改变了，但当我再次经历所有步骤时，它起作用了。我确信我这一端出了差错，但我现在找不到了。谢谢!