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.1
bind-address = 0.0.0.0
To 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: