MySQL

Managed instance of the MySQL database server.

Components

  • MySQL server
  • Basic database set up like initial root user creation.

Configuration

A my.cnf file containing basic settings is put to /etc/mysql/my.cnf. Service users may drop config file snippets containing additional options into /etc/mysql/local.

The password for MySQL’s root user can be found in /etc/mysql/mysql.passwd. This file is readable by service users.

Note

Please note that there is no default permission that allows root logins from external. When connecting to MySQL as root, please omit the -h switch:

test@test00 ~ $ mysql -u root -p<root password here>

Interaction

Service users may invoke sudo /etc/init.d/mysql restart to restart the MySQL server after configuration changes.

Monitoring

The default monitoring setup checks that the MySQL server process is running and that it responds to connection attempts to the standard MySQL port.