一、mysql忘记root密码方案
1.配置文件添加跳过密码
vi /etc/my.cnf
在[mysqld]
的段中加上一行:skip-grant-tables
2.重启mysql
CentOS6:# /etc/init.d/mysqld restart ( 或service mysqld restart )
CentOS7:#systemctl restart mysqld(或systemctl restart mariadb)
3.登录mysql
mysql -uroot -p
4.使用mysql库,更改密码,保存,退出
mysql> USE mysql ;
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;
mysql> flush privileges ;
mysql> quit
5.将MySQL的登录设置修改回来
vi /etc/my.cnf
将刚才在[mysqld]的段中加上的skip-grant-tables删除
6.再次重启
CentOS6:# /etc/init.d/mysqld restart ( 或service mysqld restart )
CentOS7:#systemctl restart mysqld(或systemctl restart mariadb)