Site5 - Built For Designers & Developers MENU

How do you change the password for a mySQL database user?

[11 Grey Star Level]

This should have been trivial to find in the KnowledgeBase. In fact, I’ll go further, it should have been obvious how to do this just by browsing the control panel. Well it wasn’t (at least for me 🙁 )

The tutorial (video) leads one through setting up a database, but one can do that by just clicking buttons and following the screens. It also says that one can change the password later. It says that, but it doesn’t say how and it doesn’t provide a pointer to the information.

Answer #1

The only way to change a MySQL user’s password is by deleting the user and recreating the same user with a new password. Just remember to reassign that user to the correct database(s) afterwards.

Answers Answered By: Kyle Ross [9 Grey Star Level]

Answer #2

Deleting the user and recreating it works.

Answers Answered By: david [10 Grey Star Level]

Answer #3

I had already worked around this problem in the obvious way — delete the user id and recreate it with the new password.

Kyle Ross and David suggest this is the only way this can be done. That may be the case, but it seems wrong not to have a straightforward “password change” mechanism.

[Aside] I haven’t “approved” Kyle and David’s answers, only because I don’t appear able to do so (I have submitted a trouble ticket about this).

Answers Answered By: JRG [11 Grey Star Level]

Answer #4

You cannot “approve” answers, it will show all of the answers you receive to your question.

As Kyle said, you need to delete and recreate the user. I have submitted an internal feature request to see if we can add a “change password” function to the MySQL section.

Answers Answered By: gmcmillan [38 Green Star Level]

Answer #5

Hi Graham. The following is a copy-and-paste from an e-mail I received:

A new comment on the post “What is the “host” for my SQL databases?” is waiting for your approval

Author : Kyle Ross (IP: ,
E-mail : [email protected]
Whois :
You should use “localhost” without the quotes as the MySQL host name.

Approve it:
Trash it:
Spam it:
Currently 5 comments are waiting for approval. Please visit the moderation panel:

Answers Answered By: JRG [11 Grey Star Level]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »

Money Back Guarantees
Click to verify BBB accreditation and to see a BBB report.