MySQL remote connection only shows some database issues

The project changed the environment, the database for the environment, so connected to the database with Navicat, the results can only see some of the database

Is it strange that my IP is forbidden to go to the server to see the connection user right

1. First look at the database that the server can see first

mysql> show databases;

2. Look at this database user and the corresponding IP situation

Select  from Mysql.user;

3. View Current User

Select current_user ();

4. View Current user permissions

 from Current_User ();

5. Create a new user

' haha '@'%'password';

6. Granting Permissions

' haha '@'%'password' with GRANT option;

7. Log in to the new user and check the permissions.

Well, there is the introduction of the company's predecessors, Navicat and other remote tools can be SSH and then local connection MySQL, suddenly feel good low ah, exposing themselves is a rookie, also recorded it

Connect the remote server via the SSH tab first

Then you can connect to MySQL like a local, how about, magical!!!

MySQL remote connection only shows some database issues