How to Change Your MySQL Password Using phpMyAdmin

I recently needed to change the password for one of my MySQL database logins. The good news is that, once I figured out the proper syntax, it was very easy to do. Here’s the rundown of how to do it…

1. Login to phpMyAdmin
2. Click the “Query window” icon
3. Run the following query:

set password = password("yournewpassword");

That’s it. Obviously, you should replace yournewpassword with your new password. Assuming it’s successful, you’ll probably get dumped back out to login screen.

Topic(s): Blogging & WebDev
Keyword(s): database, mysql, phpmyadmin, security, software