Difference between revisions of "How can I change a MySQL user's password"
Docs admin (Talk | contribs) |
Docs admin (Talk | contribs) |
||
| Line 7: | Line 7: | ||
[2] Locate the MySQL user you're wanting to delete under the 'Current Users' section. | [2] Locate the MySQL user you're wanting to delete under the 'Current Users' section. | ||
| − | [3] Click the delete icon [File:Cpanel_delete.jpg] to the right of the MySQL user you're wanting to delete. | + | [3] Click the delete icon [[File:Cpanel_delete.jpg]] to the right of the MySQL user you're wanting to delete. |
| − | [4] Click the [File:Cpanel_delete_user.jpg] button. | + | [4] Click the [[File:Cpanel_delete_user.jpg]] button. |
==Create a MySQL user through cPanel== | ==Create a MySQL user through cPanel== | ||
| Line 16: | Line 16: | ||
[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 [or use the [File:Cpanel_password_generator.jpg], it will fill in the 'Password' and 'Password (Again) fields] | + | Password: [or use the [[File:Cpanel_password_generator.jpg]], it will fill in the 'Password' and 'Password (Again) fields] |
Password (Again) | Password (Again) | ||
| − | [3] Click the [File:Cpanel_create_mysqluser.jpg] button. | + | [3] Click the [[File:Cpanel_create_mysqluser.jpg]] 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. | 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. | ||
| Line 34: | Line 34: | ||
[3] Select the database you want to assign the MySQL user to from the 'Database' drop down. | [3] Select the database you want to assign the MySQL user to from the 'Database' drop down. | ||
| − | [4] Click the [File:Cpanel_add. | + | [4] Click the [[File:Cpanel_add.jpg]] button. |
[5] Select the privileges you want the MySQL user to have. | [5] Select the privileges you want the MySQL user to have. | ||
| − | [6] Click the [File:Cpanel_make_changes.jpg] button. | + | [6] Click the [[File:Cpanel_make_changes.jpg]] button. |
[[Category:cPanel]] | [[Category:cPanel]] | ||
Revision as of 15:59, 5 October 2012
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.
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]
Password (Again)
[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 [[File:Cpanel_add.jpg]] button.
[5] Select the privileges you want the MySQL user to have.
[6] Click the 
button.
