How can I change a MySQL user's password: Difference between revisions

From Acenet Knowledgebase
Jump to navigation Jump to search
Newer edit →
test
 
No edit summary
Line 1: Line 1:
<html> 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.  
<strong>Here is how you delete a MySQL user through cPanel</strong>:
 
1) Click on the 'MySQL Databases' icon under the 'Databases' section.  
==Deleting a MySQL user through cPanel==
2) Locate the MySQL user you're wanting to delete under the 'Current Users' section.  
 
3) Click the delete icon <img title="Delete" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_delete.jpg" alt="Delete" width="16" height="17" /> to the right of the MySQL user you're wanting to delete.  
[1] Click on the 'MySQL Databases' icon under the 'Databases' section.  
4) Click the <img title="Delete User" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_delete_user.jpg" alt="Delete User" width="80" height="24" /> button.  
 
<strong>Here is how you create a MySQL user through cPanel</strong>:
[2] Locate the MySQL user you're wanting to delete under the 'Current Users' section.  
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:  
[3] Click the delete icon [File:Cpanel_delete.jpg‎] to the right of the MySQL user you're wanting to delete.  
<ul>
 
<li>Username [your MySQL user will always be prepended with your cPanel username]</li>
[4] Click the [File:Cpanel_delete_user.jpg] button.  
<li>Password [or use the <img title="Password Generator" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_password_generator.jpg" alt="Password Generator" width="139" height="22" />, it will fill in the 'Password' and 'Password (Again) fields]</li>
 
<li>Password (Again)</li>
==Create a MySQL user through cPanel==
</ul>
[1] Click on the 'MySQL Databases' icon under the 'Databases' section. (if you're not already there)  
3) Click the <img title="Create User" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_create_mysqluser.jpg" alt="Create User" width="151" height="24" /> 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.  
[2] Under the 'Add New User' section, fill in the following fields:  
<strong>Here is how you assign a MySQL user to a database:</strong>
 
1) Click on the 'MySQL Databases' icon under the 'Databases' section. (if you're not already there)  
Username [your MySQL user will always be prepended with your cPanel username]
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.  
Password [or use the [File:Cpanel_password_generator.jpg], it will fill in the 'Password' and 'Password (Again) fields]
4) Click the <img title="Add" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_add.jpg" alt="Add" width="44" height="22" /> button.  
 
5) Select the privileges you want the MySQL user to have.  
Password (Again)
6) Click the <img title="Make Changes" src="http://esupport.acenet-inc.net/knowledgebase_images/cpanel_make_changes.jpg" alt="Make Changes" width="106" height="22" /> button. </html> [[Category:cPanel]]
 
[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.
 
==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 [File:Cpanel_make_changes.jpg‎] button.
 
[[Category:cPanel]]

Revision as of 10: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 [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.

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 [File:Cpanel_password_generator.jpg], it will fill in the 'Password' and 'Password (Again) fields]

Password (Again)

[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.

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 [File:Cpanel_make_changes.jpg‎] button.

Retrieved from "https://kb.acenet.us/index.php?title=How_can_I_change_a_MySQL_user%27s_password&oldid=510"