Servers and Services

Database role

Last updated: May 2022

Support documentation / Database role

To run the database role on a server allow port 3306 on your firewall.

About

Installing the database role will install MySQL 8.0 along with the Enhance management daemon.

Customising my.cnf settings

Settings for my.cnf should be managed through your Enhance control panel. You should not attempt to manually edit my.cnf as these changes will be overridden. Before applying any settings, Enhance will check that the mysql server accepts the settings without generating an error. Settings which can be applied at runtime will be applied immediately, others might require a MySQL restart.

By default the database role inherits the global Service settings. To view your global service settings visit 'Settings > service.' The following database role settings can be overridden on a per role basis:

  • my.cnf

To override global service settings on an individual role:

  1. Open ‘Servers’ in the left side bar
  2. Select ‘Manage’ on the server
  3. Navigate to the ‘Role’ you’d like to configure custom settings for
  4. Click ‘Settings’

Any inherited global settings will be tagged 'Default'. Any custom or edited default settings will not be tagged.


phpMyAdmin

Enhance automatically installs phpMyAdmin to allow your users to manage their databases. Enhance generates a single sign-on link so the user can just press the phpMyAdmin button in their control panel and be logged directly in to phpMyAdmin without needing to select a server or enter any additional credentials.

You can change your phpMyAdmin URL under "settings" -> "platform settings" in your control panel. Resellers can also set up a custom phpMyAdmin URL for their clients.

Still need help?

Our support team are on hand to help 9am - 9pm GMT.