![\"error-wp1\"](\"https:\/\/ndthanh.net\/wp-content\/uploads\/2013\/03\/error-wp1.jpg\")
<\/p>\nSometimes, you lose your credential to your wordpress admin dashboard, i guess many of you had this question in mind : what is the quickest way to reset my admin password ?<\/p>\n
<\/p>\n
In WordPress, there is more than one way to set your password. In normal circumstances, you can do it through the WordPress interface. If you forget your password, WordPress has a built in recovery mechanism that uses email.<\/p>\n
But on some hosts, especially when email isn’t working right, sometimes you have to take different steps to reset your password. in this article, i’ll show you how to reset you admin password using command line:<\/p>\n
1. log in to MySQL<\/p>\n
\nmysql -u root -p\n<\/pre>\n<\/p>\n
enter your mysql password, then select WordPress database<\/p>\n
\nuse (name-of-database)\n<\/pre>\nlook for a table name with “users” at the end :<\/p>\n
\nshow tables;\n<\/pre>\nfind your admin user:<\/p>\n
\nSELECT ID, user_login, user_pass FROM (name-of-table-you-found)\n<\/pre>\nreset user password:<\/p>\n
\nUPDATE (name-of-table-you-found) SET user_pass=MD5('your-desired-passowrd') WHERE ID = (id#-of-account-you-are-reseting-password-for)\n<\/pre>\nto see the result (not really necessary), execute this query:<\/p>\n
\nSELECT ID, user_login, user_pass FROM (name-of-table-you-found)\n<\/pre>\n(type Control-D, to exit mysql client)<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes, you lose your credential to your wordpress admin dashboard, i guess many of you had this question in mind : what is the quickest way to reset my admin password ? In WordPress, there is more than one way to set your password. In normal circumstances, you can do it through the WordPress interface….<\/p>\n