赞
踩
1、使用set password命令
- mysql -uroot
- mysql> use mysql
- mysql> set password for 'root'@'localhost' = PASSWORD('newpass');
- mysql> flush privileges;
- mysql> select user,host,password from user;
- mysql> exit
2、使用update user表
- mysql -uroot
- mysql> use mysql
- mysql> update user set password = PASSWORD('newpass') where user = 'root';
- mysql> flush privileges;
- mysql> select user,host,password from user;
- mysql> exit;
3、使用mysqladmin命令
配置新密码:
# mysqladmin -uroot password "newpass"
重置密码:
# mysqladmin -uroot password oldpass "newpass"
4、忘记root密码时
在配置文件/etc/my.cnf的[mysqld]选项下添加skip-grant-tables
重启数据库服务:
# systemct restart mariadb
重置密码:
- mysql -uroot
- mysql> update user set password=password('newpass') where user='root' and host='localhost';
- mysql> flush privileges;
- mysql> select user,host,password from user;
- mysql> exit;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。