Difference between revisions of "How can I change a MySQL user's password"
Docs admin (Talk | contribs) |
Docs admin (Talk | contribs) m (Docs admin moved page How can I change a MySQL user's password? to How can I change a MySQL user's password without leaving a redirect) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
There is not a way to change a MySQL user's password through cPanel. You need to delete the MySQL user and then recreate it with the new password. | There is not a way to change a MySQL user's password through cPanel. You need to delete the MySQL user and then recreate it with the new password. | ||
| + | |||
| + | __TOC__ | ||
==Deleting a MySQL user through cPanel== | ==Deleting a MySQL user through cPanel== | ||
| Line 16: | Line 18: | ||
[2] Under the 'Add New User' section, fill in the following fields: | [2] Under the 'Add New User' section, fill in the following fields: | ||
| − | Username: [your MySQL user will always be prepended with your cPanel username | + | *Username: [your MySQL user will always be prepended with your cPanel username] |
| − | + | ||
| − | + | ||
| − | Password (Again) | + | *Password: [or use the [[File:Cpanel_password_generator.jpg]], it will fill in the 'Password' and 'Password (Again) fields] |
[3] Click the [[File:Cpanel_create_mysqluser.jpg]] button. | [3] Click the [[File:Cpanel_create_mysqluser.jpg]] button. | ||
Latest revision as of 13:20, 3 February 2013
There is not a way to change a MySQL user's password through cPanel. You need to delete the MySQL user and then recreate it with the new password.
Contents
Deleting a MySQL user through cPanel
[1] Click on the 'MySQL Databases' icon under the 'Databases' section.
[2] Locate the MySQL user you're wanting to delete under the 'Current Users' section.
[3] Click the delete icon 
to the right of the MySQL user you're wanting to delete.
[4] Click the 
button.
Create a MySQL user through cPanel
[1] Click on the 'MySQL Databases' icon under the 'Databases' section. (if you're not already there)
[2] Under the 'Add New User' section, fill in the following fields:
- Username: [your MySQL user will always be prepended with your cPanel username]
- Password: [or use the
, it will fill in the 'Password' and 'Password (Again) fields]
[3] Click the 
button.
The last thing to do is assign the MySQL user to the appropriate database(s). Acenet does suggest to have a different MySQL user for each of your databases for security reasons.
Assign a MySQL User to a Database
[1] Click on the 'MySQL Databases' icon under the 'Databases' section. (if you're not already there)
[2] Under the 'Add User To Database' section, select your MySQL user from the 'User' drop down.
[3] Select the database you want to assign the MySQL user to from the 'Database' drop down.
[4] Click the 
button.
[5] Select the privileges you want the MySQL user to have.
[6] Click the 
button.
