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.

Edit | Attach | Watch | Print version | History: r16 < r15 < r14 < r13 < r12 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r16 - 2012-11-21 - DanielGomezBlanco
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    DB All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback