How can I change a MySQL user's password - Revision history

Docs admin: 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

2013-02-03T13:20:35Z

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

← Older revision	Revision as of 09:20, 3 February 2013
(No difference)

Docs admin: /* Create a MySQL user through cPanel */

2013-01-06T20:01:43Z

Create a MySQL user through cPanel

← Older revision		Revision as of 16:01, 6 January 2013
Line 18:		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: [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]

	[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.		[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.

Docs admin at 20:01, 6 January 2013

2013-01-06T20:01:28Z

← Older revision		Revision as of 16:01, 6 January 2013
Line 18:		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: [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]

	[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.		[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.

Docs admin at 20:01, 6 January 2013

2013-01-06T20:01:08Z

← Older revision		Revision as of 16:01, 6 January 2013
Line 20:		Line 20:
	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)~~

	[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.		[3] Click the [[File:Cpanel_create_mysqluser.jpg‎]] button.

Docs admin at 16:01, 5 October 2012

2012-10-05T16:01:04Z

← Older revision		Revision as of 12:01, 5 October 2012
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==

Docs admin at 16:00, 5 October 2012

2012-10-05T16:00:46Z

← Older revision		Revision as of 12:00, 5 October 2012
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.jpg]‎] button.		[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.

Docs admin at 15:59, 5 October 2012

2012-10-05T15:59:57Z

← Older revision		Revision as of 11:59, 5 October 2012
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.~~jpg‎~~] button.		[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]]

Docs admin at 15:59, 5 October 2012

2012-10-05T15:59:13Z

← Older revision		Revision as of 11:59, 5 October 2012
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]]

Docs admin: test

2012-09-28T19:34:30Z

test

New page

<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.
Here is how you delete 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 <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.
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.
Here is how you 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:
<ul>
<li>Username [your MySQL user will always be prepended with your cPanel username]</li>
<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>
</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.
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.
Here is how you 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 <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.
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]]