Idea is configured to connect to the remote database mysql, or Navicat fails to connect to the remote database (solved)

stay mysql Execute the command in the environment ( Authorize any remote computer to log in to the database )：
The process is as follows ：

1. Look at all current databases ：

show databases;

2. Get into mysql database ：

use mysql;

3. see mysql All the tables in the database ：

update user set Host='%' where User='root';

4. see user Table data ：

select Host, User from user;

5. modify user In the table Host:

update user set Host='%' where User='root';

6. Last refresh ：

flush privileges;

Navicat There are two ways to connect to the database ：
Through the first SSH Connect to the server , Connect to the database in the server .

It can also be achieved directly in one step ：

However, in this way, you need to set the firewall of the server to open, that is, the security group , And the data permission of the server should be modified so that all host users can access .