玖零一族的博客
锁定和解锁MySQL用户:
ALTER USER 'user'@'localhost' ACCOUNT LOCK;
ALTER USER 'user'@'localhost' ACCOUNT UNLOCK;
配置远程访问:
创建新用户:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';
flush privileges;
已存在用户:
update user set host ='%' where user ='root';
flush privileges;
Copyright © 2017-2024 www.90cdk.cn 玖零一族 版权所有 浙ICP备17018905号-1