openstack和mysql忘记密码重置密码-KVM

yum install -y mariadb mariadb-server python2-python

systemctl enable mariadb

mysql_secure_installation 

初始化数据库 y,n,y,y

mysql -uroot -p000000

登录数据库，以6个0为密码登录

============忘记密码先停止再修改mysql密码==============

systemctl stop mariadb ; 

pkill -9 mysql ; 

#杀进程，最该权限

rm -rf /var/lib/mysql/* ; 

#清除缓存

systemctl restart mariadb ; 

chown mysql:mysql /var/run/mariadb/mariadb.pid

修改

-------修改密码-------

#!/bin/bash

mysql_secure_installation <<eof

123456

y

000000

000000

y

n

y

y

eof

----------------------

=================================