Navicat Unable to connect to MySQL

Today's newly installed Linux, installed to use NAVICAT to connect the database, found that the connection is not

Thought, smoothed

First type: Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Workaround:

First, check whether the system firewall allows 3306 port access

If not, please refer to the Linux

Second, the local IP (that is, your computer's IP) does not have access to the database permissions, open, the error message is as follows:

1. Go to MySQL

2. Select Database Update data

Use MySQL;

Update user set host= '% ' where user= ' root ' limit 1;

Flush privileges;

3, test, get it done!

Second type: ERROR 2003 (HY000): Can ' t connect to MySQL server on ' hostxxxxx ' (10061)

Error reason: The MYSQLD database service did not start.

Check: Task Manager in Windows, or unix/linux under Ps-aux | grep MySQL to look at. Confirm that the service is started.

Processing: Starting the MYSQLD service

Navicat Unable to connect to MySQL