MySQL remote link method and Flush-hosts

Sometimes you will find that you want to use remote link mysql

1 first to the MySQL host on the machine to modify the MySQL table, the fastest is to copy the local localhost, now phpmyadmin copy function is very useful, and then the host column in the localhost to the corresponding IP (remote client IP) can be.

Of course, change localhost to% can also, but not so all can log on ...

Don't forget that the last restart of the MySQL service will take effect. /etc/init.d/mysql restart

2 of course there is direct grant authorization, this is the knock command ...

Sometimes too many remote errors will be blocked, that is, block,

ERROR 1129 (HY000): Host ' 192.168.7.189 ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts '

1. To log in to MySQL on the local (192.168.7.61) command line, enter the command flush hosts (not flush-hosts) to reset the maximum number of errors.

2. Of course, you can also change the maximum number of errors,, the benevolent see of the beholder ...

MySQL remote link method and Flush-hosts