mysql 修改密码 需要授权

CREATE USER 'root'@'managezb.ztu.edu.cn' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'managezb.z.edu.cn';
FLUSH PRIVILEGES;



select host,user from user;
update user set host='192.168.5.172' where user='root' and host='%';

#单个IP   *.* 表示所有的数据库 ，可以针对某个数据进行设置，如 on 库名.表名
grant all privileges on *.* to root@'%' identified by 'gtxy_Mysql@123' with grant option;
grant all privileges on *.* to root@'localhost' identified by 'gtxy_Mysql@123' with grant option;
grant all privileges on *.* to root@'127.0.0.1' identified by 'gtxy_Mysql@123' with grant option;
 
flush privileges;
 
#IP段,使用%代替IP
grant all privileges on *.* to root@'192.168.1.%' identified by '123' with grant option;
or
grant all privileges on *.* to root@'192.168.%.%' identified by '123' with grant option;
 
flush privileges;