Change a MySQL user password

Posted October 12, 2003 by Quinn McHenry in MySQL

How do I update a user’s password in my MySQL server?


For the user molly to change her password to TrckTrt, she would run this command from the shell:

mysqladmin -u molly -p password TrckTrt

The mysqladmin program will prompt for the old password.

 

About Quinn McHenry

Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
View more articles by Quinn McHenry

The Conversation

Follow the reactions below and share your own thoughts.