MySQL Common error resolution

Mysql _1018 Error

mysql> use dbname; Database changed MySQL>1018 (HY000): Can'./dbname/' (errno:13)

Reason:
The owner of this library directory is not correct, using chown modification, the table information is normal.
At this point, you can #ls-l or #ll view the details of the directory, you can find the owner of the Library directory is not MySQL

Workaround:

#chown-R mysql:mysql/var/lib/mysql/dbname

where/var/lib/mysql/dbname storage directory for MySQL database

Mysql _1045 Error

1. Open the/etc/mysql/debian.cnf file and record the user name and password provided in the [Client] section:

2, after the command, follow the prompts to enter the password

#mysql-udebian-sys-maint-< client>

3. Execute the following command sequentially (where NewPassword is changed to the password you want to set)

mysql< usemysql;mysql< UPDATE user SET Password=password ('newpassword' where user='root'; MySQL< FLUSH Privileges;mysql< quit

4. Try to Login

Mysql-uroot-< newpassword>

5, ordinary users can not login

' Root '@ '%'root' @' localhost ' "' With GRANT OPTION;

MySQL Common error resolution