Setting up how to connect to a MySQL database remotely

When mysql5.6.37 is installed, by default, only local logins are allowed, and remote logins are forbidden.

You can now install the connection tools locally, such as SQLyog or Navicat.

After logging in, switch to MySQL database

Execute the following 2 statements

GRANT  All Privileges  on *. *  to [Email protected] ' % '  by ' 123456 '  Privileges

Format:Grant on database name. Table name User @ Login host  by "User password";

 All  privileges represents all permissions, androot indicates the user to be empowered; % is the remote login IP (the IP you use to log in), if you want to restrict the login IP, add the IP you allow to log in, such as 192. 168.0. 55,% means no limit IP,123456 is the password of the user Telnet, and finally  run the privileges

Select User  from User ; View user Status

Setting up how to connect to a MySQL database remotely