Creating a MySQL User
To be able to access a MySQL database you must first create a MySQL user. Once the user has been created, that user can be assigned different access rights to different databases. This can also allow you to grant access by multiple users with different rights to some or all of your databases. This demonstration shows how to create a MySQL user.
Simply follow the simple instructions below.
-
Select the MySQL Databases link.
Top of page -
Complete the following instructions.
- Enter the username you wish to use for this user (this is restricted in length to 16 characters, after being prefixed by your username and an underscore_. If you enter a username beyond this limit it will be truncated),
- Enter the password for the user you are creating,
- Click the Create User button.
Top of page -
Well Done! You have successfully created a MySQL user.
Top of page
TwentyHost™ is a trading name of Future Internet Services Ltd, PO Box 6840, Derby, DE22 4WZ. Telephone: 0845 641 0776. Fax: 0870 116 9928
Registered Office: 56 Friar Gate, Derby, DE1 1DF. Registered in England number 6058991.
This website was designed, coded and programmed by Future Internet Services Ltd.
Copyright 2006, 2007 Future Internet Services Ltd. All rights reserved. E&OE.
The screen shot images (screen dumps) used in our demonstrations are all copyright and may be trademarks or trade names of their respective owners.
cPanel®, WHM™ and Web Host Manager™ are trademarks of cPanel Inc, all images ©cPanel Inc. 2001-2007.
Outlook is a trademark of Microsoft Corporation, Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation.
Thunderbird™ is a trademark of Mozilla Foundation, Mozilla® product screen shot(s) reproduced in accordance with the Mozilla Trademark Policy.
