1.登录服务器mysql后台
# mysql -uroot -p
2.进入和查询用户表
mysql> use mysql;
mysql> select host,user from user;
3.更新只允许此IP能访问该数据库
mysql> update user set host ='125.121.34.16' where host='%';
4.给此IP赋权
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'125.121.34.16' IDENTIFIED BY '123456' WITH GRANT OPTION;
5.刷新权限
mysql> flush privileges;