14,953
edits
排除 MySQL 技術疑難問題: Difference between revisions
Jump to navigation
Jump to search
→錯誤 1044 (42000): 拒絕使用者 'USER'@'localhost' 存取資料庫 'DATABASE_NAME'
| Line 220: | Line 220: | ||
$ mysqldump -h 127.0.0.1 -u USER -p --skip-lock-tables DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | $ mysqldump -h 127.0.0.1 -u USER -p --skip-lock-tables DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | ||
</pre> | </pre> | ||
=== 錯誤 1827 (HY000): 密碼哈希不符合預期格式。檢查是否使用了正確的密碼算法與 PASSWORD() 函數。 === | |||
錯誤的 SQL 查詢如下： | |||
<pre> | |||
CREATE USER 'test'@'localhost' IDENTIFIED BY PASSWORD 'my_password'; | |||
</pre> | |||
解決方案： | |||
(1) 檢查帳戶是否已創建 | |||
<pre> | |||
SELECT User,Host FROM mysql.user; | |||
</pre> | |||
(2a) 如果帳戶已創建，為該帳戶設定密碼。 | |||
<pre> | |||
SET PASSWORD FOR 'test'@'localhost' = PASSWORD('my_password'); | |||
</pre> | |||
(2b) 如果帳戶未創建，重新創建帳戶。 | |||
<pre> | |||
CREATE USER 'test'@'localhost' IDENTIFIED BY 'my_password'; | |||
</pre> | |||
參考資料 | |||
* [http://dev.mysql.com/doc/refman/5.7/en/create-user.html MySQL :: MySQL 5.7 參考手冊 :: 14.7.1.2 CREATE USER 語法] | |||
* [http://dev.mysql.com/doc/refman/5.7/en/set-password.html MySQL :: MySQL 5.7 參考手冊 :: 14.7.1.7 SET PASSWORD 語法] | |||
* [http://dev.mysql.com/doc/refman/5.7/en/drop-user.html MySQL :: MySQL 5.7 參考手冊 :: 14.7.1.3 DROP USER 語法] | |||
== 資源和環境錯誤 == | == 資源和環境錯誤 == | ||