mysql登录不上大概密码忘记能够尝尝一下无密码登陆

mysql登录不上依然密码忘记能够尝尝一下无密码登入

 

以下一波神操作!!

 

第意气风发关闭数据库服务(数据库在Centos7版本以上只怕Redhat版本上被改名换姓为mariadb)

systemctl stop mariadb

跳过密码验证(& 将该进程放到后台运转)
mysqld_safe –skip-grant-tables &
一直利用MySQL无密码登陆

[root@Darius ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MariaDB connection id is 1
Server version: 5.5.44-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input
statement.

MariaDB [(none)]>

校勘密码

 

MariaDB [(none)]> update mysql.user set password=password(‘123456′)
where user=’root’;
ps -aux|grep mysql找到pid,kill杀死Mariadb进程
重启Mariadb服务