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:
-
Connect to the server via SSH
-
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
-
-
Comment with a preceding
#
or delete the lines under the[mysqld]
section:bind-address = 127.0.0.1
skip-name-resolve = 1 -
Restart the MariaDB service:
# systemctl restart mariadb
Comments
0 comments
Please sign in to leave a comment.