MariaDB 10.0.33 Configuring MariaDB for Remote Client Access
![Creative The name of the picture](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO9GURib1T8z7lCwjOGLQaGtrueEthgQ8LO42ZX8cOfTqDK4jvDDpKkLFwf2J49kYCMNW7d4ABih_XCb_2UXdq5fPJDkoyg7-8g_YfRUot-XnaXkNYycsNp7lA5_TW9td0FFpLQ2APzKcZ/s1600/1.jpg)
![Creative The name of the picture](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYQ0N5W1qAOxLP7t7iOM6O6AzbZnkXUy16s7P_CWfOb5UbTQY_aDsc727chyphenhyphen5W4IppVNernMMQeaUFTB_rFzAd95_CDt-tnwN-nBx6JyUp2duGjPaL5-VgNO41AVsA_vu30EJcipdDG409/s400/Clash+Royale+CLAN+TAG%2523URR8PPP.png)
up vote
0
down vote
favorite
I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.
MariaDB docs does not take into account this version in its documentation.
Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf
I comment this out as the example, but in my case I had to add it manually.
[mysqld]
...
#skip-networking
...
#bind-address = <some ip-address>
...
And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.
Check if por is open
sudo nmap -PN -p 3306 -sV server_ip
The port wasn't listening from remote ips.
16.04 remote-access mariadb
add a comment |Â
up vote
0
down vote
favorite
I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.
MariaDB docs does not take into account this version in its documentation.
Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf
I comment this out as the example, but in my case I had to add it manually.
[mysqld]
...
#skip-networking
...
#bind-address = <some ip-address>
...
And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.
Check if por is open
sudo nmap -PN -p 3306 -sV server_ip
The port wasn't listening from remote ips.
16.04 remote-access mariadb
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.
MariaDB docs does not take into account this version in its documentation.
Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf
I comment this out as the example, but in my case I had to add it manually.
[mysqld]
...
#skip-networking
...
#bind-address = <some ip-address>
...
And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.
Check if por is open
sudo nmap -PN -p 3306 -sV server_ip
The port wasn't listening from remote ips.
16.04 remote-access mariadb
I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time.
MariaDB docs does not take into account this version in its documentation.
Following the instructions i modified the file my.cnf that in my case it was /etc/mysql/my.cnf
I comment this out as the example, but in my case I had to add it manually.
[mysqld]
...
#skip-networking
...
#bind-address = <some ip-address>
...
And as I already have an account with remote permissions, I just restarted the mysql service but nothing happened.
Check if por is open
sudo nmap -PN -p 3306 -sV server_ip
The port wasn't listening from remote ips.
16.04 remote-access mariadb
16.04 remote-access mariadb
asked Feb 23 at 22:36
Joe
71431124
71431124
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
English
The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.
I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.
/etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
...
I hope this could save time to someone else.
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
English
The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.
I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.
/etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
...
I hope this could save time to someone else.
add a comment |Â
up vote
0
down vote
accepted
English
The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.
I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.
/etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
...
I hope this could save time to someone else.
add a comment |Â
up vote
0
down vote
accepted
up vote
0
down vote
accepted
English
The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.
I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.
/etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
...
I hope this could save time to someone else.
English
The answer was already in the file my.cnf where it explains the configuration order so that the last file is the one that applies.
The problem I got is that the MariaDB docs recommends to comment out the lines skip-networking and bind-address.
In my case, to comment out lines does nothing, it doesn't override the previous configuration, because it only applies if it defines something new, so I had to go to the source where it was defined that keywords to comment that out in the first place.
I had to comment out this file /etc/mysql/mariadb.conf.d/50-server.cnf where it was firstly defined skip-networking and bind-address.
/etc/mysql/my.cnf
# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
...
I hope this could save time to someone else.
edited Feb 24 at 9:10
answered Feb 24 at 9:04
Joe
71431124
71431124
add a comment |Â
add a comment |Â
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%2f1009175%2fmariadb-10-0-33-configuring-mariadb-for-remote-client-access%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