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. 

## B.3.2.12 Commands out of sync 

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. 

## B.3.2.13 Ignoring user 

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. 

## B.3.2.14 Table ’tbl_name’ doesn’t exist 

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: 

•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. 

•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. 

You can check which tables are in the default database with SHOW TABLES . See Section 13.7.7, “SHOW Statements” . 

## B.3.2.15 Can’t initialize character set 

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: 

