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

From Acenet Knowledgebase
Jump to: navigation, 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 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.

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 Cpanel delete.jpg to the right of the MySQL user you're wanting to delete.

[4] Click the 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 Cpanel password generator.jpg, it will fill in the 'Password' and 'Password (Again) fields]

[3] Click the 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 Cpanel add.jpg button.

[5] Select the privileges you want the MySQL user to have.

[6] Click the Cpanel make changes.jpg button.

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