unknown variable 'bind-address=ip'
Clash Royale CLAN TAG#URR8PPP up vote
1
down vote
favorite
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
asked Feb 10 at 0:03
dat tutbrus
410421
add a comment |Â
up vote
1
down vote
favorite
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
asked Feb 10 at 0:03
dat tutbrus
410421
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
@jet I already put my IP in, but the command is probably reading off of something else.[ip]is just an example, the real content has a legit IP.
– dat tutbrus
Feb 10 at 4:29
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
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
asked Feb 10 at 0:03
dat tutbrus
410421
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
mysql mariadb
asked Feb 10 at 0:03
dat tutbrus
410421
asked Feb 10 at 0:03
dat tutbrus
410421
asked Feb 10 at 0:03
dat tutbrus
410421
asked Feb 10 at 0:03
dat tutbrus
410421
asked Feb 10 at 0:03
dat tutbrus
410421
410421
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
@jet I already put my IP in, but the command is probably reading off of something else.[ip]is just an example, the real content has a legit IP.
– dat tutbrus
Feb 10 at 4:29
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59
add a comment |Â
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
@jet I already put my IP in, but the command is probably reading off of something else.[ip]is just an example, the real content has a legit IP.
– dat tutbrus
Feb 10 at 4:29
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
@jet I already put my IP in, but the command is probably reading off of something else.
[ip] is just an example, the real content has a legit IP.– dat tutbrus
Feb 10 at 4:29
@jet I already put my IP in, but the command is probably reading off of something else.
[ip] is just an example, the real content has a legit IP.– dat tutbrus
Feb 10 at 4:29
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
2
down vote
accepted
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.
answered Feb 10 at 10:20
Thomas
3,29481325
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
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.
answered Feb 10 at 10:20
Thomas
3,29481325
add a comment |Â
up vote
2
down vote
accepted
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.
answered Feb 10 at 10:20
Thomas
3,29481325
add a comment |Â
up vote
2
down vote
accepted
up vote
2
down vote
accepted
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.
answered Feb 10 at 10:20
Thomas
3,29481325
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.
answered Feb 10 at 10:20
Thomas
3,29481325
answered Feb 10 at 10:20
Thomas
3,29481325
answered Feb 10 at 10:20
Thomas
3,29481325
answered Feb 10 at 10:20
Thomas
3,29481325
3,29481325
add a comment |Â
add a comment |Â
Â
draft saved
draft discarded
Â
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1004714%2funknown-variable-bind-address-ip%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
put something like: bind-address = 127.0.0.1
– jet
Feb 10 at 2:40
@jet I already put my IP in, but the command is probably reading off of something else.
[ip]is just an example, the real content has a legit IP.– dat tutbrus
Feb 10 at 4:29
Delete that line in the file and type it by hand.
– jet
Feb 10 at 16:59