Mysql 修改Root密码和访问IP限制

最新推荐文章于 2024-08-02 04:13:40 发布

weixin_34360651

最新推荐文章于 2024-08-02 04:13:40 发布

阅读量634

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/Kxvz/blog/715077

版权

为什么80%的码农都做不了架构师？>>>

service mysqld stop

mysqld_safe --skip-grant-tables&

mysql -u root mysql

use mysql;

delete from user where user is null;
delete from user where user = '';
UPDATE user SET password=PASSWORD("1234") WHERE user='root';
UPDATE user SET host='localhost' where user='root' and host='%';
UPDATE user SET host='192.168.%.%' where user='root' and host='localhost.localdomain';
FLUSH PRIVILEGES;

select user,host,password from user;

exit;

service mysqld restart

转载于:https://my.oschina.net/Kxvz/blog/715077