Unable to update Plesk: /usr/bin/mysql: unknown variable 'bind-address=127.0.0.1'

Created:

2016-12-21 10:49:16 UTC

Modified:

2017-08-08 13:13:44 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to update Plesk: /usr/bin/mysql: unknown variable 'bind-address=127.0.0.1'

Symptoms

Unable to update Plesk:

===> Upgrading database
Trying to start service mariadb...
active done
Trying to establish test connection... /usr/bin/mysql: unknown variable 'bind-address=127.0.0.1' /usr/bin/mysql: unknown variable 'bind-address=127.0.0.1' failed ERROR while trying to establish test connection Check the error reason(see log file: /var/log/plesk/install/plesk_17.0.17_installation.log), fix and try again

/etc/my.cnf contains the following lines:

[mysql]
bind-address = 127.0.0.1

Cause

A typo in /etc/my.cnf file: there should be [mysqld] instead of [mysql] section

Resolution

Edit /etc/my.cnf file:

1. Backup the original file to the root directory:

# cp /etc/my.cnf ./

2. Modify /etc/my.cnf file so that all parameters are stored in [mysqld] section, for example:

[mysqld]
bind-address = 127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

max_allowed_packet=256M

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

3. Restart mysql service

 

 

Have more questions? Submit a request
Please sign in to leave a comment.