MySQL FAQ workaround.

1. Problem: MySQL boot error (Linux)

[Email protected] ~]# service mysqld restart

Another MySQL daemon already running with the same UNIX socket.
Starting mysqld: [FAILED]

Workaround:

[Email protected]~] Mv/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock.bak

[[Email protected]~]# service mysqld Restart

2. Problem: Navicat connection mysql: 1130 error (Windons)

1130:hostxxx.xxx.xxx.xxx is isn't allowedto connect to this MySQL server

Workaround:

Mysql>use MySQL
Mysql>update User Set host = '% ' where user = ' root ';
Mysql>flush privileges;
Mysql>select ' host ', ' user ' from user where user= ' root ';
Mysql>quit

3. Problem: Navicat connection MySQL: reported 1045 error

1045 Access denied Foruser ' root ' @ ' localhost ' (using Password:yes)

Workaround:

/etc/init.d/mysqld stop
Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
Mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' 123456 ') where user= ' root ';

(UPDATEuser SET password=password (' 123456 ') where user= ' root ' and host= ' root ' orhost= ' localhost ';)

mysql> FLUSH privileges;
Mysql> quit

/etc/init.d/mysqld restart

4. Problem: Navicat connection mysql: reported 10060 error

Can ' t connect to MySQL Server (10060)

Workaround:

Http://database.51cto.com/art/201107/274565.htm ( focus on checking if the 3306 port is already open )

5. Question: How to create another account to connect to MySQL server remotely

Mysql>usemysql
Mysql>grant all privileges on * * to ' sems_mysql ' @ '% ' identified by ' Gziscassems ' with GRANT OPTION;

6. Problem: Navicat connection mysql: reported 10061 error

2003-CAN.T Connect to MySQL Server on xxx.xxx.xxx.xxx (10061)

Workaround:

Start the MySQL service

[[Email protected] ~]# service mysqld start

7 Questions: Navicat Connection MySQL : Newspaper ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '

/etc/init.d/mysqldstop
Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
Mysql-u Root MySQL

mysql> Delete from user where user= ';
Mysql> FLUSH privileges;//Remember to say this, otherwise if you close the previous terminal, the original error will appear
Mysql> quit

MySQL FAQ workaround.