MySQL Database

ID #57

How do I change my database password?

Applies to: Grid System

You can change your database password easily in a single step from within Modwest™ Onsite.

Another way to change your database password is by using the MySQL Monitor at a shell prompt. To do it this way instead, first SSH into with the username/password you signed up with. Then, to get from the shell prompt to the MySQL Monitor, see this FAQ.

Finally, at the "mysql>" prompt, type:

set password = password("yournewpassword");

To leave the Monitor, type: quit

For more convenient access to the MySQL Monitor, see this FAQ on how to use a .my.cnf file.

Last update: 2011-07-12 16:28
Author: FAQ Admin
Revision: 1.3

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 3.41 (22 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ

Comment of Anonymous:
If you change your mysql password, then you will need to edit all your scripts and programs that use the old password.
Added at: 2003-01-29 14:09

Comment of Anonymous:
See on how to connect to the MySQL Monitor.
Added at: 2002-05-19 15:56

Comment of Anonymous:
If you don't know your MySQL password, you will have to reset it yourself in your control panel.

You can only change the mysql password from a shell prompt if you know the old password.

Added at: 2004-01-13 19:17