Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to crack the root login password of MariaDB5.5 database. The content of the article is of high quality, so Xiaobian shares it with you for reference. I hope you have a certain understanding of relevant knowledge after reading this article.

[root@localhost ~]# mysql -uroot -p123 Forgot root login password

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Find and run mysqld_safe to bypass MariaDB 5.5 database password validation

[root@localhost ~]# find / -name mysqld_safe/usr/bin/mysqld_safe[root@localhost ~]# /usr/bin/mysqld_safe --skip-grant-tables &

Log in to MariaDB 5.5 database directly using mysql command and modify root login password

[root@localhost ~]# 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 [mysql]> UPDATE user SET password=password("New-password") WHERE user='root';Query OK, 3 rows affected (0.00 sec)Rows matched: 3 Changed: 3 Warnings: 0MariaDB [mysql]> flush privileges;Query OK, 0 rows affected (0.00 sec)MariaDB [mysql]> exitBye

Login to MariaDB5.5 database with new password New-password

[root@localhost ~]# ps auUSER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMANDroot 3986 0.0 0.1 115380 2084 tty1 Ss+ 19:53 0:02 -bashroot 22483 0.0 0.1 115384 2076 pts/0 Ss 21:54 0:00 -bashroot 22910 0.0 0.0 113252 1592 pts/0 S 21:59 0:00 /bin/sh /usr/bin/mysqld_safe --skimysql 23066 0.3 4.6 839268 86192 pts/0 Sl 21:59 0:00 /usr/libexec/mysqld --basedir=/usrroot 23091 0.0 0.0 151056 1824 pts/0 R+ 22:00 0:00 ps au[root@localhost ~]# kill -9 22910[root@localhost ~]# 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[1]+ Killed /usr/bin/mysqld_safe --skip-grant-tables

You cannot log into the MariaDB 5.5 database using any other password.

[root@localhost ~]# mysql -uroot -pNew-passwordddERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)[root@localhost ~]# rpm -qa mariadbmariadb-5.52 -1.el7.x86_64 About how to crack MariaDB5.5 database root login password shared here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.