"Allow local MySQL server to accept external connections" checkbox disappears after activation

Symptoms

When accessing Plesk > Tools&Settings > Database servers > MySQL or MariaDB, the following option is missing:

Cause

This behaviour was caused by Plesk bug identified as #PPP-63234, which has been resolved in more recent updates of Plesk.

Resolution

Update Plesk to the latest version to resolve the issue.

As an alternative workaround, execute the following steps for the option to appear:

1. Connect to the server via SSH
2. Edit the /etc/mysql/my.cnf file on Debian based distributions or /etc/my.cnf on RHEL-based distributions
3. Edit the "bind-address" parameter value to the following:

PLESK_INFO: bind-address = ::

     4. Save the changes