MariaDB密码重置
如果记得root的密码:
mysqladmin -uroot -paminglinux password "aming-linux" //用此方式将原密码aminglinux重置为aming-linux
如果不记得原密码:
# vi /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/tmp/mysql.sock
skip-grant //添加这一行
此时登录root就不需要密码了
# mysql -uroot
> use mysql //切换到mysql库
> desc user; //查看user表的所有字段
密码存在了authentication_string字段里,因此修改此字段
> update user set authentication_string=password("wangzb") where user='root' and host='localhost'; //update该字段修改密码
退出MariaDB,删除/etc/my.cnf里面的skip-grant 重启服务
# vi /etc/my.cnf
修改普通用户密码:
# mysql -uroot -pmysql
> use mysql;
> select user,host from user;
+------+-----------+
| user | host |
+------+-----------+
| bbs | 127.0.0.1 |
| blog | 127.0.0.1 |
| root | 127.0.0.1 |
| root | ::1 |
| | localhost |
| root | localhost |
| | wangzb01 |
| root | wangzb01 |
+------+-----------+
> update user set authentication_string=password("wangzb") where user='root' and host='localhost'; //update用户及对应主机的密码