Product Documentation

Create MySQL databases and users

Jun 05, 2015
Updated: 2013-02-11

To create a new MySQL database

  1. From the Services Manager menu bar, click Services > MySQL > Databases.
  2. Under Database Management, click New MySQL Database. The Database Details box appears.
  3. Enter the name of the new database.
    Note: The database name consists of a default prefix (customer code) and the name you specify. The entire database name, including prefix, cannot exceed 16 characters.
  4. Click Provision to create the database.

To add new MySQL users

  1. From the Services Manager menu bar, click Services > MySQL > Users.
  2. Under MySQL User Management, click New MySQL User.
  3. Enter the user name and password for the new user.
  4. Ensure the Is Enabled check box is selected. Clearing this check box disables the user account.
  5. Under Databases, select the databases to which you want to assign access.
  6. To configure permissions for each database, click Edit and then select one of the following roles:
    • ReadOnly allows users to execute queries and view records.
    • DBA allows users to perform most database functions, with the exception of referencing table columns as part of foreign key constraints.
    • User allows users to run queries as well as create, modify, and remove records.
    • Full allows users to perform all database functions.
  7. Click Update to save your selection.
  8. Click Provision to create the user account.