MySQL error and solve the whole introduction

If you have a problem with a database that changes the appropriate code, you typically restart MySQL. If you encounter MySQL problem can restart the MySQL to see if the problem can be resolved.

1005: Failed to create table

1006: Failed to create database

1007: Database already exists, failed to create database

1008: Database does not exist, delete database failed

1009: Unable to delete database file causes database failure to be deleted

1010: Unable to delete data directory causes database failure to be deleted

1011: Failed to delete database file

1012: Unable to read records in system tables

1016: Unable to open file

Start => All Programs => Attachment => command Prompt after clicking

Enter MySQL on the hard drive letter

directory where CD MySQL resides

CD bin

Enter Myisamchk-f d:usr/local/mysql/data/bbs/pw_members. Myi

Ps:d:usr/local/mysql/data/bbs is the path to your forum database

-F Depending on the circumstances of the choice, generally can also choose-r

Note that your system C disk or put the database hard disk space is enough, generally less than 1G is prone to errors.

or repaired with the Mysqlcheck command. Specific method: Use command line to enter Mysql/bin directory, execute

Mysqlcheck-o-R Phpwind-uroot-p

Where Phpwind is your database name, root is your database username, and then prompts you to enter the password.

Then you'll be able to fix your database.

1020: The record has been modified by another user

1021: The hard disk space is not enough, please increase the hard disk free space

1022: Duplicate the keyword, change record failed

1023: Error occurred while closing

1024: Error reading file

1025: An error occurred while changing the name

1026: Write File Error

1032: The record does not exist

1036: The datasheet is read-only and cannot be modified

1037: The system is low on memory, please reboot the database or reboot the server

1038: There is not enough memory for sorting, please increase the sort buffer

1040: The maximum number of connections to the database, please increase the number of connections available to the database

1041: Low system memory

1042: Invalid host name

1043: Invalid connection

1044: The current user does not have permission to access the database

1045: Cannot connect the database, the username or the password is wrong

Methods: Ensure that the sql_config.php username and password are correct in the Forum data directory. If the user forgets the password for the database, the password can be modified as follows:

If MySQL is running, stop first.

Start Mysql:bin/safe_mysqld--skip-grant-tables &

You can enter MySQL without the need for a password.

Then it's

>use MySQL

>update User Set Password=password ("New_pass") where user= "root";

>flush privileges;

If the username and password of the database are correct, make sure that the data directory has write permissions. For Windows hosts, you can set the users user group to have write permissions in the data directory. The class Linux system can be modified with chmod-r 777 data.