允许root用户在一个特定的IP进行远程登录,并具有所有库任何操作权限,具体操作如下:
端口就不多说了 肯定要开放端口
然后
依次执行下面四条命令即可.
在本机先使用root用户登录mysql:mysql -u root -p"youpassword"
mysql -u root -p"youpassword"
进行授权操作:GRANT ALL PRIVILEGES ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword" WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword" WITH GRANT OPTION;
重载授权表:FLUSH PRIVILEGES;
FLUSH PRIVILEGES;
退出mysql数据库:exit
exit