MySQL remote Logon

By default, remote connection is not allowed for ysql, because of the high security risks.

You need to manually add remote accessDatabase.

Method 1. log on to MySQL locally, change the "host" item in the "user" table in the "MySQL" database, and change "localhost" to "%"

# Mysql-u root-proot
Mysql> use MySQL;
Mysql> Update user set host = '%' where user = 'root ';
Mysql> select host, user from user;

Method 2: direct authorization (Recommendation)

Use the root user on 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;

Allow the address 202.11.10.253 to connect to all MySQL databases with the root user and password dboomysql, and grant the select, insert, update, and delete permissions. # Mysql-u root-proot
Grant select, insert, update, delete on *. * to root @ "202.11.10.253" identified by "dboomysql ";

Allow the address 202.11.10.253 to use the root user and password dboomysql to connect to all MySQL Databases and grant all permissions. # Mysql-u root-proot
Grant all on *. * to root @ "202.11.10.253" identified by "dboomysql"

After the MySQL service is restarted, you can use the graphical database management software (Navicat MySQLIs a good choice) Remote Access to MySQL