IT源码网

怎样重置MySQL密码

itxm 2021年03月09日 数据库 407 0
systemctl stop mysqld 
 
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 
 
systemctl start mysqld 
 
mysql -u root 
 
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost'; 
 
FLUSH PRIVILEGES; 
 
quit;

 

评论关闭
IT源码网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!

怎样启动Nginx并设置开机自动运行