Turn on MySQL remote login

The development process often encountered the problem of remote access to MySQL, every time need to search, feel too much trouble, recorded here, also convenient for me to check later.

First access the native MySQL (with SSH login terminal, enter the following command):

Mysql-uroot-p

Enter the password after login, enter the following statement:

 Use MySQL; Grant  All Privileges  on *. *  to ' User '@ '%' by'password'  withGrantoption;

which

User is the username
MySQL default is root
Password is the password to set itself
% indicates any host, or IP address can be specified

This allows any host to be accessed remotely.

Example:

Grant  All Privileges  on *. *  to ' Root '@'192.168.1.100'by'withGrant  option;

That is, allow 192.168.1.100 to log on without a password as root.

All right, that's it, I hope it helps you.

This article GitHub address:

https://github.com/mike-zhang/mikeBlogEssays/blob/master/2017/20170212_ open mysql remote login. MD

Welcome to Supplement

Turn on MySQL remote login