Navicat Connect to the pits in VMware under Ubuntu mysql5.7

1. There is a problem with the MySQL connection under the navicat virtual machine: 2003-can ' t connect MySQL Server on ' 192.168.*.* ' (10038).

Solution:

Method: Direct Authorization (recommended)

To use the root user from any host, password: youpassword (your root password) to connect to the MySQL server:
# mysql-u Root-proot
Mysql>grant all privileges on * * to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION;

2. Because of an operation error, the problem is logged in again: "Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)".

Solution:

1. Skip Password to login

Modify the MySQL configuration file by Adding two sentences to the paragraph in [mysqld]:

Skip-name-resolve
Skip-grant-tables

2. Log in to MySQL and change the password

/usr/bin/mysql log in to MySQL

Use MySQL;
Update Mysql.user set Authentication_string=password (' root ') where user= ' root ';
Flush privileges;
Quit

3. Restart the MySQL service

Service MySQL Restart

Navicat Connect to the pits in VMware under Ubuntu mysql5.7