Common Errors When Using MySQL Programs Check also the error code that you get with  perror . One reason the server cannot write to a table is that the file system is full: shell>  perror 28 OS error code 28: No space left on device If you get an error of the following type during startup, it indicates that the file system or directory used for storing data files is write protected. Provided that the write error is to a test file, the error is not serious and can be safely ignored. Can’t create test file /usr/local/mysql/data/master.lower-test If you get  Commands out of sync; you can’t run this command now  in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using  mysql_use_result()  and try to execute a new query before you have called  mysql_free_result() . It can also happen if you try to execute two queries that return data without calling  mysql_use_result()  or  mysql_store_result()  in between. If you get the following error, it means that when  mysqld  was started or when it reloaded the grant tables, it found an account in the  user  table that had an invalid password. Found wrong password for user ’ some_user ’@’ some_host ’; ignoring user As a result, the account is simply ignored by the permission system. To fix this problem, assign a new, valid password to the account. If you get either of the following errors, it usually means that no table exists in the default database with the given name: Table ’ tbl_name ’ doesn’t exist Can’t find file: ’ tbl_name ’ (errno: 2) In some cases, it may be that the table does exist but that you are referring to it incorrectly: You can check which tables are in the default database with  SHOW TABLES . See Section 13.7.7, “SHOW Statements” . You might see an error like this if you have character set problems: MySQL Connection Failed: Can’t initialize character set  charset_name This error can have any of the following causes: 5296 B.3.2.15 Can’t initialize character set B.3.2.14 Table ’tbl_name’ doesn’t exist B.3.2.13 Ignoring user B.3.2.12 Commands out of sync •Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. •Because MySQL uses directories and files to store databases and tables, database and table names are case-sensitive if they are located on a file system that has case-sensitive file names.