My SQL is a popular database management system. It allows you to add, access, and process stored data. This document will guide you through:

• Creating My SQL database and its users
• Editing My SQL databases (php My Admin)
• Changing My SQL disk quota
• Changing user passwords
• Adding My SQL users and granting them privileges

Creating My SQL Database and Its Users

My SQL users cannot exist separately from My SQL databases. You must stick to the following sequence:

1. Create a database
2. Add My SQL users to each created database.

However, My SQL users can be shared by different databases.

To create a My SQL database, do the following:

1. Select My SQL in the Databases menu and My SQL DB creation Wizard automatically appears.
2. On the form that shows enter the name of the database and database description if needed:
   

   

   NOTE:
   Starting from version 2.3.1, new My SQL databases are created with the username_ prefix, where username is a unique identifier that contains either first letters of the name of an account under which this database is created, or that account name's first letters and a unique number if there are several account names starting with the same letters. This is done to prevent the creation of databases with the same name under different users.

3. Agree with additional charges if any.
4. In the form that appears, create a new user or grant privileges to users of other databases:



• Add a new user to the database you have just created. User roles are explained below. Click Add user.
• Choose roles for users of other databases so they can use your new database. Click Grant.


5. Click Finish to complete creating your My SQL database.

You can edit the content of your databases using the php My Admin utility that comes with your control panel. To run php My Admin, do the following:

1. Select My SQL DBs in the Databases menu.
2. In the form that appears, click the name of the existing My SQL Database you want to edit or the Edit icon on its right:



3. In the form that appears, click Built in php My Admin control panel to start editing your database:

   

4. Follow the instructions of the php My Admin control panel to edit your My SQL DB.

Changing My SQL disk quota.

My SQL disk quota is the maximum allowed size of one My SQL database. If you exceed this quota, you'll be charged for over limit at a different (usually higher) price.

To change My SQL disk quota, do the following:

1. Select My SQL DBs in the Databases menu.
2. Click the My SQL Database or the Edit icon on its right:
3. Click the Change button against the Quota field and enter the new quota:



4. Click Submit.
5. Agree to additional charges.

Changing user passwords.

To change user password in the MySQL database, do the following:

1. Select My SQL DBs in the Databases menu.
2. Click the My SQL Database or the Edit icon on its right:
3. On the My SQL database management page click the Change password icon next to the DB user.



4. Enter new password and click the Change button.

Adding My SQL users and granting them privileges.

Here you will learn how to add new users to an existing My SQL database.

1. Select My SQL DBs in the Databases menu.
2. Click the My SQL Database or the Edit icon on its right:
3. On the form that shows, click the Add icon against the Database users field.
4. Fill the following form:
   

   

   Each user role involves a fixed set of privileges on this specific database:

   Role:	Set of privileges:
   read	select
   read/write	select, insert, delete, update
   dba	select, insert, update, drop, create, alter, index

   
   
5. Click the Add or Grant button and agree to additional charges.
6. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.



7. Check or uncheck the desired privileges and press the Submit button.

Note: For more information on My SQL access privileges, please refer to www.mysql.com.

IMPORTANT: any changes in user privileges will be applied to the whole selected database.