How do you change the password for a mySQL database user?
]
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).
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.
]
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
http://qa.site5.com/advanced/what-is-the-host-for-my-sql-databases/
Author : Kyle Ross (IP: 206.53.89.99 , d-206-53-89-99.cpe.metrocast.net)
E-mail : [email protected]
URL :
Whois : http://whois.arin.net/rest/ip/206.53.89.99
Comment:
You should use “localhost” without the quotes as the MySQL host name.
Approve it: http://qa.site5.com/wp-admin/comment.php?action=approve&c=36
Trash it: http://qa.site5.com/wp-admin/comment.php?action=trash&c=36
Spam it: http://qa.site5.com/wp-admin/comment.php?action=spam&c=36
Currently 5 comments are waiting for approval. Please visit the moderation panel:
http://qa.site5.com/wp-admin/edit-comments.php?comment_status=moderated
Answer this Question
You must be Logged In to post an Answer.
Not a member yet? Sign Up Now »
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.