2002 - Forgot admin password

Overview

The key is that rConfig uses MD5 for hashing the password, this makes sense because the field can only take 32 characters. This are the command I use.

[root@localhost rconfig]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.1.69 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use rconfig_db;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> UPDATE users SET password='21232f297a57a5a743894a0e4a801fc3' WHERE username='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

The important thing to remember is that this hash "21232f297a57a5a743894a0e4a801fc3" is equivalent to "admin" which is the original password of rconfig in default install. You can always generate a new hash if you don't want to make it the default by using the following link www.md5hashgenerator.com/index.php Or using the CLI, I am not a CLI fan so I did it the easy way. Hope this help someone, it took me a few hours to figure this out.