Product Documentation

MySQL

Jun 05, 2015
Updated: 2013-02-11

The MySQL service for Services Manager enables service providers to grant customers the ability to create, modify, and remove MySQL databases. Users can perform limited database operations according to the user roles that are assigned to them.

Supported versions

The MySQL service is supported for use with MySQL 5.0 and 5.1.

Server requirements

When configuring the server that will be running MySQL, perform the following tasks:
  • Run MySQL on the default port 3306.
  • Allow local and remote connections.
  • On applicable firewalls, open the following ports:
    • Port 3306, to allow connections to the MySQL server.
    • Port 8095, to allow connections between the MySQL server and the Services Manager web and Provisioning servers.

Account requirements

Services Manager requires logon access to administer databases and users. If you are using multiple MySQL servers, use the same account for all of them (suggested name: CortexMySQLHosting). This account must have DBA (grant all) global privileges.

Supported database user roles

User roles are comprised of MySQL permissions. The following table describes the permissions that are included in each role.
MySQL Permissions ReadOnly Role DBA Role User Role Full Role
SELECT X X X X
INSERT   X X X
UPDATE   X X X
DELETE   X X X
EXECUTE X X X X
SHOW VIEW   X   X
CREATE   X   X
ALTER   X   X
REFERENCES       X
INDEX   X   X
CREATE VIEW   X   X
CREATE ROUTINE   X   X
ALTER ROUTINE   X   X
DROP   X   X
CREATE TEMPORARY TABLES   X X X
LOCK TABLES   X X X

Service deployment overview

Deploying the MySQL service involves the following tasks:
  • Install the web service on the MySQL server.
  • Configure the MySQL service using the control panel.
  • Provision the service to customers.

For deployment instructions, see Deploy the MySQL service.