MySQL Remote Connection - What i am missing?
Clash Royale CLAN TAG#URR8PPP up vote
0
down vote
favorite
I am experiencing some difficulties to configure MySQL Server and allow remote connections. I am currently using Ubuntu Server 16.04 and the latest MySQL version.
This is the error Workbench throws me when I try to connect:
I have been following and reading tutorials to configure it at this point. So, the relevant things i have done for this are:
Install the latest version of MySQL
Create a user granting full privileges for local and outsiders.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';I modified the MySQL configuration file
/etc/mysql/mysql.conf.d/mysqld.cnfusing nano. The change i made was replacing this:bind-address = 127.0.0.1For this:
bind-address = 0.0.0.0To allow remote connections.
Using UFW I am allowing the port 3306 and 3306/tcp. Using the command
sudo ufw statusI am getting this (i am showing only the relevant):3306 (v6) ALLOW Anywhere (v6)
3306/tcp (v6) ALLOW Anywhere (v6)
Which as far I know is all I need to connect remotely right?
The way I am connecting:
MySQL users:
server mysql iptables ufw mysql-workbench
edited Apr 3 at 3:21
Karl Richter
2,26573361
asked Apr 2 at 22:44
Kaba
1
add a comment |Â
up vote
0
down vote
favorite
I am experiencing some difficulties to configure MySQL Server and allow remote connections. I am currently using Ubuntu Server 16.04 and the latest MySQL version.
This is the error Workbench throws me when I try to connect:
I have been following and reading tutorials to configure it at this point. So, the relevant things i have done for this are:
Install the latest version of MySQL
Create a user granting full privileges for local and outsiders.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';I modified the MySQL configuration file
/etc/mysql/mysql.conf.d/mysqld.cnfusing nano. The change i made was replacing this:bind-address = 127.0.0.1For this:
bind-address = 0.0.0.0To allow remote connections.
Using UFW I am allowing the port 3306 and 3306/tcp. Using the command
sudo ufw statusI am getting this (i am showing only the relevant):3306 (v6) ALLOW Anywhere (v6)
3306/tcp (v6) ALLOW Anywhere (v6)
Which as far I know is all I need to connect remotely right?
The way I am connecting:
MySQL users:
server mysql iptables ufw mysql-workbench
edited Apr 3 at 3:21
Karl Richter
2,26573361
asked Apr 2 at 22:44
Kaba
1
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I am experiencing some difficulties to configure MySQL Server and allow remote connections. I am currently using Ubuntu Server 16.04 and the latest MySQL version.
This is the error Workbench throws me when I try to connect:
I have been following and reading tutorials to configure it at this point. So, the relevant things i have done for this are:
Install the latest version of MySQL
Create a user granting full privileges for local and outsiders.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';I modified the MySQL configuration file
/etc/mysql/mysql.conf.d/mysqld.cnfusing nano. The change i made was replacing this:bind-address = 127.0.0.1For this:
bind-address = 0.0.0.0To allow remote connections.
Using UFW I am allowing the port 3306 and 3306/tcp. Using the command
sudo ufw statusI am getting this (i am showing only the relevant):3306 (v6) ALLOW Anywhere (v6)
3306/tcp (v6) ALLOW Anywhere (v6)
Which as far I know is all I need to connect remotely right?
The way I am connecting:
MySQL users:
server mysql iptables ufw mysql-workbench
edited Apr 3 at 3:21
Karl Richter
2,26573361
asked Apr 2 at 22:44
Kaba
1
I am experiencing some difficulties to configure MySQL Server and allow remote connections. I am currently using Ubuntu Server 16.04 and the latest MySQL version.
This is the error Workbench throws me when I try to connect:
I have been following and reading tutorials to configure it at this point. So, the relevant things i have done for this are:
Install the latest version of MySQL
Create a user granting full privileges for local and outsiders.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';I modified the MySQL configuration file
/etc/mysql/mysql.conf.d/mysqld.cnfusing nano. The change i made was replacing this:bind-address = 127.0.0.1For this:
bind-address = 0.0.0.0To allow remote connections.
Using UFW I am allowing the port 3306 and 3306/tcp. Using the command
sudo ufw statusI am getting this (i am showing only the relevant):3306 (v6) ALLOW Anywhere (v6)
3306/tcp (v6) ALLOW Anywhere (v6)
Which as far I know is all I need to connect remotely right?
The way I am connecting:
MySQL users:
server mysql iptables ufw mysql-workbench
server mysql iptables ufw mysql-workbench
edited Apr 3 at 3:21
Karl Richter
2,26573361
asked Apr 2 at 22:44
Kaba
1
edited Apr 3 at 3:21
Karl Richter
2,26573361
asked Apr 2 at 22:44
Kaba
1
edited Apr 3 at 3:21
Karl Richter
2,26573361
edited Apr 3 at 3:21
Karl Richter
2,26573361
edited Apr 3 at 3:21
Karl Richter
2,26573361
2,26573361
asked Apr 2 at 22:44
Kaba
1
asked Apr 2 at 22:44
Kaba
1
asked Apr 2 at 22:44
Kaba
1
1
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47
add a comment |Â
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1021451%2fmysql-remote-connection-what-i-am-missing%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
Oh, one more thing, inside the mysqlid.cnf there was suppose to be a line like this: "skip-networking" ... I was suppose to comment it or remove it, but i did not saw any line like that.
– Kaba
Apr 2 at 22:47