Mysql修改密码的方式如果忘记密码--skip-grant-tables 1、alter user alter user test@'localhost
Mysql修改密码的方式
如果忘记密码--skip-grant-tables
1、alter user
alter user test@'localhost' identified by 'xxxx!';
2、grant
show grants for test@'localhost';
GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWord '*xxxxxxxxxxxxx';
GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxx';
3、set password
set password for test@'localhost'=password('xxx')
4、update mysql.user
mysql> UPDATE mysql.user SET Password = PASSWORD('newpass') WHERE user = 'test' and host='localhost';
mysql> FLUSH PRIVILEGES;
5、mysqladmin
mysqladmin -u test password "newpass" #第一次设置
mysqladmin -u test password oldpass "newpass" #如果root已经设置过密码,采用如下方法
--结束END--
本文标题: MySQL 用户和权限管理
本文链接: https://www.lsjlt.com/news/36581.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-09
2024-05-09
2024-05-09
2024-05-09
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0