{{ t('Configuration Wizard: MySQL Server') }}
{{ t('Host Information') }}
{{ t('MySQL Information') }}

{{ t('MySQL Server') }}

  1. {{ t('To enable external databases access you have to change the {0} of your MySQL server.') }}
    {{ t('Changing the bind address can be a potential security issue!') }}
    {{ t('The bind-address is configured in my.cnf. Most likely this file is located at {0} or {1}', { "0": "/etc/mysql/mysql.conf.d/mysqld.cnf", "1": "/etc/mysql/my.cnf" }) }}
  2. {{ t('Change the bind-address from 127.0.0.1 to the external address of the system or use 0.0.0.0 to bind to all interfaces.') }}
    bind-address = 0.0.0.0
  3. {{ t('Restart the MySQL server to apply the changes.') }}
    systemctl restart mysql.service
  4. {{ t('Create a new MySQL user for {0}', {"0": systemName}) }}
    CREATE USER 'monitoring'@'{{ serverAddr }}' IDENTIFIED BY 'secure_password';
    GRANT SELECT, SHOW VIEW ON *.* TO 'monitoring'@'{{ serverAddr }}';
    {{ t('Please replace {0} with the address of the {1} server and set a secure password', { "0": serverAddr, "1": systemName }) }}