How do I reset the password for a mysql database user?
Within the MySQL Databases area of the cPanel control panel, there is no apparent facility for changing the password of a database user. You'll see the ability to create a new database user, and the ability to delete an existing user, but nothing specifically intended to let you change the password of an existing user.
If you are having trouble with a php or perl script connecting to a database, sometimes it simply means you're not connecting with the correct password. It would be handy to be able to reset that password within the control panel to ensure it matches the password configured in your php script.
While the procedure is not obvious - the simplest way to reset the password for a database user is to simply fill out the Add New User area with the existing username, and the password you want that user to have. This will update the existing user with the new password.
Comment
or post as a guest
Be the first to comment.