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

From Acenet Knowledgebase
Jump to navigation Jump to search
test
 
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
 
(7 intermediate revisions by the same user not shown)
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.  
__TOC__
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.  
==Deleting a MySQL user through cPanel==
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>:
[1] Click on the 'MySQL Databases' icon under the 'Databases' 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:  
[2] Locate the MySQL user you're wanting to delete under the 'Current Users' section.  
<ul>
 
<li>Username [your MySQL user will always be prepended with your cPanel username]</li>
[3] Click the delete icon [[File:Cpanel_delete.jpg‎]] to the right of the MySQL user you're wanting to delete.  
<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>
[4] Click the [[File:Cpanel_delete_user.jpg]] button.  
</ul>
 
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.  
==Create a MySQL user through cPanel==
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.  
[1] Click on the 'MySQL Databases' icon under the 'Databases' section. (if you're not already there)  
<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)  
[2] Under the 'Add New User' section, fill in the following fields:  
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.  
*Username: [your MySQL user will always be prepended with your cPanel username]
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: [or use the [[File:Cpanel_password_generator.jpg]], it will fill in the 'Password' and 'Password (Again) fields]
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]]

Latest revision as of 09: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.

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.

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