13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Troubleshooting of MySQL
| Line 108: | Line 108: | ||
$ sudo chmod 774 /Applications/XAMPP/xamppfiles/var/mysql/XXXMacBook-Pro.local.err | $ sudo chmod 774 /Applications/XAMPP/xamppfiles/var/mysql/XXXMacBook-Pro.local.err | ||
</pre> | </pre> | ||
==== ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) ==== | |||
Solutions | |||
* Check if the disk space where mysql data folder located is enough. e.g. Input {{kbd | key=df -h}} on {{Linux}} | |||
* More on [http://stackoverflow.com/questions/11045279/error-1005-hy000-cant-create-table-errno-150 mysql - ERROR 1005 (HY000): Can't create table (errno: 150) - Stack Overflow]. | |||
==== ERROR 1006 (HY000): Can't create database 'DATABASE_NAME' (errno: 28) ==== | |||
Solutions | |||
* Check if the disk space where mysql data folder located is enough. e.g. Input {{kbd | key=df -h}} on {{Linux}} | |||
* More on [http://stackoverflow.com/questions/18719748/error-1006-hy000-cant-create-database-errno-13-mysql-5-6-12 ERROR 1006 (HY000) Can't create database (errno: 13) MySQL 5.6.12 - Stack Overflow]. | |||
==== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) ==== | |||
Solution: | |||
* Check the typo of user name. | |||
* Check the typo of password. | |||
* Escape the password if it contains special characters e.g. {{kbd | key=<nowiki>mysql -u root -p'PASSWORD'</nowiki>}}<ref>[http://superuser.com/questions/123928/escaping-a-password-using-mysqldump-console escape characters - Escaping a password using mysqldump console - Super User]</ref> | |||
==== Err 1054 - Unknown column in 'where clause' ==== | ==== Err 1054 - Unknown column in 'where clause' ==== | ||
| Line 161: | Line 179: | ||
Solution: | Solution: | ||
* Check if the MySQL service is running or not. If not, start the MySQL service. | * Check if the MySQL service is running or not. If not, start the MySQL service. | ||
==== Error Code: 2013. Lost connection to MySQL server during query ==== | ==== Error Code: 2013. Lost connection to MySQL server during query ==== | ||