Enable MySQL Remote Access

Recently, tomcat was developed for database migration. to access the database with other users, you must enable the remote access permission;

In addition, we know that there are two ways to remotely access Mysql: Authorization and table modification;

The figure indicates that the slave account has been enabled,

You can see that you already have a root user. The host column can be a hostlist or IP address. You can modify the domain name or IP address =;

1 \ authorization method:

Use mysql;

Grant all privileges on *. * to leo @ '%' identified by "leo ";

Leo users can access it anywhere;

2 \ This table method:

Allows the root user to access the database anywhere.

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

In this way, you can