Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

1,044 bytes removed , 12 May 2024

14,953

edits

@@ Line 137: / Line 137: @@
 * [https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp mysql - Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT - Stack Overflow]
-== ERROR 1827 (HY000): The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function. ==
-Wrong sql query as follows:
-<pre>
-CREATE USER 'test'@'localhost' IDENTIFIED BY PASSWORD 'my_password';
-</pre>
-Solution:
-(1) Check if the account was created or not
-<pre>
-SELECT User,Host FROM mysql.user;
-</pre>
-(2a) If the account was created, set the password for the account.
-<pre>
-SET PASSWORD FOR 'test'@'localhost' = PASSWORD('my_password');
-</pre>
-(2b) If the account was NOT created, re-create the account.
-<pre>
-CREATE USER 'test'@'localhost' IDENTIFIED BY 'my_password';
-</pre>
-references
-* [http://dev.mysql.com/doc/refman/5.7/en/create-user.html MySQL :: MySQL 5.7 Reference Manual :: 14.7.1.2 CREATE USER Syntax]
-* [http://dev.mysql.com/doc/refman/5.7/en/set-password.html MySQL :: MySQL 5.7 Reference Manual :: 14.7.1.7 SET PASSWORD Syntax]
-* [http://dev.mysql.com/doc/refman/5.7/en/drop-user.html MySQL :: MySQL 5.7 Reference Manual :: 14.7.1.3 DROP USER Syntax]
 == Database and Table Operation Errors ==