MySQL remote Logon Settings

1. By default, MySQL only allows local login, so you need to modify the configuration file to bind the address to comment out:
Vim/etc/MySQL/My. CNF
Find the following content:
# Instead of skip-networking the default is now to listen only on
# Localhost which is more compatible and is not less secure.
# Bind-address = 127.0.0.1 <--- comment out this line and you can log on remotely.

2. Restart the MySQL service:
Sudo service MySQL restart

3. Set a user that can log on remotely. Take user Tom as an example.
$ Mysql-u root-P (Log On As the root user and grant the Tom user permission)
Mysql> Update mysql. User set host = '%' where user = 'Tom'

4. Authorized users (taking Tom as an example) databases that can be remotely accessed (taking testdb as an example)
Mysql> grant all on testdb. * To 'Tom '@' % ';
Mysql> flush privileges;

5. Remote logon Test

Mysql-H hostname-P protnum-u username-P

For example, MySQL-H 192.168.0.1-P 3306-u tom-P