Changing MySQL DB user password in Cpanel 11?

Discussion in 'MySQL' started by avord, Apr 21, 2011.

  1. #1
    I'm going nuts looking for a way to change database user's passwords through the CPanel 11. I've looked at Mysql Databases where you can create and add users, and phpMysqlAdmin and I just can't find any user administration. When I try to add the same username with a different password then I get an error: "That mysql username is taken". Is there any way to change db-user password without deleting and adding new user again every time I want to change the password?
     
    avord, Apr 21, 2011 IP
  2. x319

    x319 Well-Known Member

    Messages:
    90
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    103
    #2
    You can't change a password. What you can do however, which is very simple; delete the user and create a user with the same username with the new password you want. Then just give the user permissions once again the database(s) they should control.
     
    x319, Apr 21, 2011 IP