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…
- Login to phpMyAdmin
- Click the “Query window” icon
- 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.