Scheduled Plesk Backups fail to make database dump: Error: Forcing protocol to TCP due to option specification.

Symptoms

• Scheduled Backups logs shows the error:

  Database "example_db"
  Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.
  mysqldump: Got error: 1045: "Access denied for user 'admin'@'127.0.0.1' (using password: YES)" when trying to connect

• MariaDB version is greater than 10.6

• MariaDB was upgraded from another version.

• The configuration file my.cnf contains the following lines:

  bind-address = 127.0.0.1
  skip-name-resolve = 1

Cause

In MariaDB versions later than 10.6, the bind-address and skip_name_resolve lines should not be present on the configuration files.

Resolution

Delete or comment out the lines on the configuration file:

1. Connect to the server via SSH

2. Edit the my.cnf file, Vi Editor can be used:

   • on CentOS/RHEL-based distributions:

     # vi /etc/my.cnf

   • on Debian/Ubuntu-based distributions:

     # vi /etc/mysql/my.cnf

3. Comment with a preceding # or delete the lines under the [mysqld] section:

   bind-address = 127.0.0.1
   skip-name-resolve = 1

4. Restart the MariaDB service:

   # systemctl restart mariadb