MySql 设置IP 访问

MySql 设置IP 访问| Id | Title | DateAdded | SourceUrl | PostType | Body | BlogId | Description | DateUpdated | IsMarkdown | EntryName | CreatedTime | IsActive | AutoDesc | AccessPermission |

| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------|
| 14963646| MySql 设置IP 访问| 2021-07-02T15:55:00| | BlogPost|

##1.默认安装目录
cd C:\Program Files\mysql-5.7.16-winx64\bin

##2.登陆mysql数据库
mysql -uroot -p

##3.查看user表
use mysql;
select host,user from user;

##4.更新IP
update user set host = '172.16.7.136' where user = 'root';

##5.授权
Grant all on *.* to 'root'@'%' identified by 'DKYao2021!@#$' with grant option;
flush prvileges;

##6.重启mysql
net stop mysql
net start mysql

| 648658| | 2021-07-02T15:55:00| false| | 2021-07-02T15:55:22.72| true| ##1.默认安装目录cd C:\Program Files\mysql-5.7.16-winx64\bin ##2.登陆mysql数据库mysql -uroot -p ##3.查看user表use mysql;select host,user from user; ##4.更新IPupdate us| Anonymous|