MySQL

Creating Databases

To create a MySQL database:

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

    Note: New MySQL 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:

  5. Add a new user to the database you have just created: choose user role and click Add user.
  6. Choose roles for users of other databases so they can use your new database. Click Grant.
  7. Click Finish to complete creating your MySQL database.

Changing MySQL Disk Quota

MySQL disk quota is the maximum allowed size of one MySQL database. If you exceed this quota, you will be charged for overlimit at a different (usually higher) price.

To change MySQL disk quota:

  1. Select MySQL databases in the Databases menu.
  2. Click the MySQL 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 if any.

Adding MySQL Users And Granting Them Privileges

To add new users to an existing MySQL database:

  1. Select MySQL databases in the Databases menu.
  2. Click the MySQL Database or the Edit icon on its right.
  3. On the form that shows, click Add against the Database users field and fill the 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
  4. Click the Add or Grant button and agree to additional charges.
  5. To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.

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

Note: For more information on MySQL access privileges, please refer to www.mysql.com. Any changes in user privileges will be applied to the whole selected database.

Changing User Passwords

To change user password in the MySQL database:

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

  4. Enter new password and click the Change button.

Editing MySQL Databases with phpMyAdmin

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel.

To run phpMyAdmin, do the following:

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

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

  4. Follow the instructions of the phpMyAdmin control panel to edit your MySQL database.