Getting started with MySQL

Connecting to the database

You can connect to the database using any of the available tools for this task: the mysql CLI command and MySQL Workbench officially supported by ORACLE, or any other 3rd party tools (such as phpMyAdmin).

From now on, any further reference will take for granted the use of the CLI mysql tool.

Connection string

The connection string is formed following the <[ip_alias].cern.ch:[port]> template. This information will be provided to you once the instance is created.

User management

The owner of the database instance will be considered the database administrator (DBA), and provided with a temporal password with full administrator capabilities. The user is required to change the temporal password as soon as possible.

Two special DB users exist called dod_mysql and dod_dbmon. The DBA must not change any parameter related to these two users as they are used for management and monitoring purposes. Any modification affecting this users could interfere with the correct behaviour of the platform, and will be considered a break of the user agreement.

As a DBA, the user will have the ability to grant access to new users and manage their access privileges. For further information about how to correctly manage user privileges and accounts, please refer to the official MySQL documentation.

For any question regarding the management of the DB instance, please read the Official MySQL Documentation.