时间:2021-07-01 10:21:17 帮助过:3人阅读
2、使用初始密码登录
#mysql -u root -p
3、修改密码
mysql> ALTER USER ‘root‘ IDENTIFIED BY ‘xxxxxxxxx‘;
mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘xxxxxxxx‘;
4、刷新权限表
mysql> flush privileges;
5、退出、重启
mysql> exit
#service mysqld restart
二、忘记修改后的密码
检查mysql是否启动,如果启动,关闭mysql
//查看mysql状态
#ps -ef | grep mysql
#service mysql stop
3、启动mysql,并进入mysql
#service mysqld start
#mysql -u root
修改密码
连接mysql这个数据库,修改用户密码
mysql> use mysql;
mysql> update mysql.user set authentication_string=password(‘123456‘) where user=‘root‘;
mysql> flush privileges;
mysql> exit
centos7下,忘记mysql2.5.版本的登录密码,如何重置及登陆
标签:centos flush mys HERE exit 重启 跳过 service 文件