破解MariaDB数据库的管理员登录密码
本文档以实战的形式介绍破解 MariaDB5.5 数据库的 root 登录密码
忘记 root 登录密码
# mysql -uroot -p123 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)查找并运行 mysqld_safe 程序绕开 MariaDB5.5 数据库密码验证
# find / -name mysqld_safe/usr/bin/mysqld_safe# /usr/bin/mysqld_safe --skip-grant-tables &直接使用 mysql 命令登录 MariaDB5.5 数据库并修改 root 登录密码
# mysqlWelcome to the MariaDB monitor.Commands end with ; or \g.Your MariaDB connection id is 1Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set (0.00 sec)MariaDB [(none)]> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedMariaDB > UPDATE user SET password=password("New-password") WHERE user='root';Query OK, 3 rows affected (0.00 sec)Rows matched: 3Changed: 3Warnings: 0MariaDB > flush privileges;Query OK, 0 rows affected (0.00 sec)MariaDB > exitBye使用新密码 New-password 登录 MariaDB5.5 数据库
# ps auUSER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMANDroot 39860.00.1 1153802084 tty1 Ss+19:53 0:02 -bashroot 224830.00.1 1153842076 pts/0 Ss 21:54 0:00 -bashroot 229100.00.0 1132521592 pts/0 S 21:59 0:00 /bin/sh /usr/bin/mysqld_safe --skimysql 230660.34.6 839268 86192 pts/0 Sl 21:59 0:00 /usr/libexec/mysqld --basedir=/usrroot 230910.00.0 1510561824 pts/0 R+ 22:00 0:00 ps au# kill -9 22910# mysql -uroot -pNew-passwordWelcome to the MariaDB monitor.Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.52-MariaDB MariaDB ServerCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> MariaDB [(none)]> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set (0.00 sec)MariaDB [(none)]> exitBye+Killed /usr/bin/mysqld_safe --skip-grant-tables使用其他密码不能登录 MariaDB5.5 数据库
# mysql -uroot -pNew-passworddERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)# rpm -qa mariadbmariadb-5.5.52-1.el7.x86_64总结
以上就是破解 MariaDB5.5 数据库的 root 登录密码的实战方法，希望能帮助到大家。
666
页:
[1]