Home / ubuntu / Questions / 1004714
Accepted
dat tutbrus
Asked: 2018-02-10 16:03:00 +0800 CST

unknown variable 'bind-address=ip'

  • 772

I was trying to run some mysql command, but then when I run it, this happens

mysql: unknown variable 'bind-address=[ip]'

Stuff looks different in my.cnf:

[mysqld]
bind-address = [ip]
port = 3306

50-server.cnf:

[mysqld]

user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

bind-address = [ip]

mysql.cnf:

[mysql]
bind-address = [ip]
port = 3306

ps -aux | grep mysql:

mysql     4171  0.7  3.1 730344 96612 ?        Ssl  15:54   0:03 /usr/sbin/mysqld
mysql mariadb

2 Answers

  1. Best Answer

    There is no bind-address option for mysql in MariaDB. This option is related to the daemon part mysqld.

    So remove the bind-address from your [mysql] section in the mysql.cnf file.

    • 3

  2. I had this problem, I wanted to work in the client mariadb or mysql of the terminal and in the client dbeaver, so I had to add this lines in this file /etc/mysql/my.cnf

    [mysqld]

bind-address = 0.0.0.0

    It is important to add the label [mysqld], if you don´t add only works in dbeaver and it doesn´t work in the client mariadb. Adding this label works in both.

    Remember reset the service to apply the changes.

    sudo systemctl restart mariadb

    Use the command of the terminal mysql or mariadb to use these clients

    mysql

mariadb
    • 1