I use Ubuntu 16.04 and MySQL 5.7.16 and trying to connect from Windows10 with Workbench; My aim is to be able to login from any computer, anywhere --- I have no intention to allow only one IP.
I get failed connect after filling credentials:
method | TCP/IP hostname | IPv4 port | 3306 username | I use the MySQL root user (the one I used to login to PHPmyadmin with) password | MySQL root password.
The error is:
Is not allowed to connect to this MySQL server
[mysqld] # # * Basic Settings # 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 # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 0.0.0.0 # 127.0.0.1
Why it's not likely a firewall issue:
Given I use CSF-LFD as firewall software, I don't use the native UbuntuFireWall (UFW). Yet, I did allow port 3306 ongoing and outgoing in csf.conf, and restarted CSF via
sudo csf -r.
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN -
Given these circumstances, what else can prevent my remote login?