If you know the email you used to create your account. Then you can use the request password link on your login page.
If you’ve forgotten your email address, or your site has been hacked (gulp) and your login info changed, you can reset your password using phpMyAdmin.
What is phpMyAdmin?
phpMyAdmin is a web-based, database management program with a graphical user interface, offered by many web hosts. WordPress stores its data in MySQL databases, and so phpMyAdmin is a good way to see edit the database directly if you’re not familiar with shells, command lines, and such.
But to use phpMyAdmin, it has to be installed on a web-server and have access to your database files.
Many web hosts provide phpMyAdmin support built-in. Here’s how to find it within a Dreamhost account:
- Login at http://www.dreamhost.com/
- Click on ‘Goodies’ in the Main Menu.
- Click ‘MySQL Databases.’
- Find the MySQL Server and Hostname for the website you need to edit. Your hostname will usually include the URL of your website, eg. “mysql.mysite.com.”
- Click on the phpMyAdmin link for that hostname under the ‘Web Administration’ column.
If you do not have phpMyAdmin available. You can install and configure it on your web server. You will need:
- A copy of the latest phpMyAdmin software, downloaded to your computer.
- An FTP client to access your web server’s files.
- Login and password for FTP access to your web server.
- The administrator login & password for your MySQL database.
Download the latest version of phpMyAdmin. You should choose the 2.X version unless you know your web host is using PHP 5.2 and MySQL 5 or greater.
Extract the zipped file to a folder on your desktop.
Login to your web server with your FTP client. Create a new directory (folder) inside your website’s root directory (“mysite.com”) and name it “phpmyadmin.”
Upload the unzipped phpMyAdmin files and folders to the folder you just created.
Visit http://mysite.com/phpmyadmin with your web browser, and you will see the login page for phpMyAdmin.
Login using the administrator login & password for your blog’s MySQL database. (You can find this through your web host control panel.)
Congratulations! You now have phpMyAdmin access to your WordPress databases.
You can now use phpMyAdmin to reset your WordPress password if your email reset is lost or compromised. Here’s a good tutorial. Ignore the cpanel stuff if you installed phpMyAdmin to a specific web directory as described above.