MySQL older versions(<<5.x)<\/p>\n\n\n\n
http:\/\/www.miraclesalad.com\/webtools\/md5.php<\/pre>\n\n\n\n2. Get access to the MySQL command prompt.<\/p>\n\n\n\n
#mysql -u root -p\nEnter password:<\/pre>\n\n\n\nEnter the MySQL root password.<\/p>\n\n\n\n
3. Get the list of databases currently on your server.<\/p>\n\n\n\n
mysql>SHOW databases;\n\n+--------------------+\n| Database |\n+--------------------+\n| information_schema |\n| cphulkd |\n| eximstats |\n| foryou_wp |\n| horde |\n| leechprotect |\n| modsec |\n| mysql |\n| performance_schema |\n| roundcube |\n| whmxfer |\n+--------------------+\n11 rows in set (0.00 sec)\n\nmysql><\/pre>\n\n\n\n4. Select your WordPress database ( here it is foryou_wp)<\/p>\n\n\n\n
mysql> use foryou_wp;\nDatabase changed\nmysql><\/pre>\n\n\n\n5. Find the table name with ‘users’ at the end ( here it is wp_users)<\/p>\n\n\n\n
mysql> show tables;\n+------------------------+\n| Tables_in_foryou_wp |\n+------------------------+\n| wp_commentmeta |\n| wp_comments |\n| wp_links |\n| wp_options |\n| wp_postmeta |\n| wp_posts |\n| wp_term_relationships |\n| wp_term_taxonomy |\n| wp_terms |\n| wp_usermeta |\n| wp_users |\n+------------------------+\n11 rows in set (0.00 sec)\n\nmysql><\/pre>\n\n\n\n6. To get the details about the user, user ID, etc; enter the following command.<\/p>\n\n\n\n
mysql> SELECT ID, user_login, user_pass FROM wp_users;\n+----+------------+------------------------------------+\n| ID | user_login | user_pass |\n+----+------------+------------------------------------+\n| 1 | admin | d51b9f2635741a855162826d2e13185c |\n+----+------------+------------------------------------+\n1 row in set (0.00 sec)\n\nmysql><\/pre>\n\n\n\n7. Update the new password with the following command.<\/p>\n\n\n\n
UPDATE (name-of-table-you-found) SET user_pass=\"(MD5-string-you-made)\" WHERE ID = (id#- of-account-you-are-reseting-password-for);<\/pre>\n\n\n\nThe command should look like this:<\/p>\n\n\n\n
mysql>UPDATE wp_users SET user_pass=\"f367084816d16de2660a1d1493c0a62c\" WHERE ID = 1;<\/pre>\n\n\n\n8. Make sure that the password has changed.<\/p>\n\n\n\n
mysql> SELECT ID, user_login, user_pass FROM wp_users;\n+----+------------+------------------------------------+\n| ID | user_login | user_pass |\n+----+------------+------------------------------------+\n| 1 | admin | f367084816d16de2660a1d1493c0a62c |\n+----+------------+------------------------------------+\n1 row in set (0.00 sec)\nmysql><\/pre>\n\n\n\n9. Quit from MySQL prompt.<\/p>\n\n\n\n
mysql>quit\nBye\nroot@server [~]#<\/pre>\n\n\n\nMySQL recent versions (5.x)<\/p>\n\n\n\n
Skip step 1 and replace step 7 with the following.<\/p>\n\n\n\n
mysql>UPDATE (name-of-table-you-found) SET user_pass = MD5('\"(new-password)\"') WHERE ID = (id#-of-account-you-are-reseting-password-for);<\/pre>\n\n\n\nThe command should look like this:<\/p>\n\n\n\n
mysql> UPDATE wp_users SET user_pass = MD5 ('Qwerty123') WHERE ID = 1;\nQuery OK, 1 row affected (0.01 sec)\nRows matched: 1 Changed: 1 Warnings: 0\n\nmysql><\/pre>\n\n\n\nThat’s it!<\/p>\n\n\n\n
<\/div>\n\n\n\nAffordable Python Hosting<\/h3>
Powerful Python hosting doesn’t have to break the bank. Start with our LaunchPad plan at just \u20b955\/month. Reliable, secure, and fast.<\/p><\/div>