0

I'm trying to connect on my mysql database when I'm not on localhost - on localhost it's working. Everytime I wish to connect, I don't have any error, but only a timeout exec...

Here is what I've done so far

  • create a user on mysql who can access to any hosts("%")
  • purge the iptables
  • my port 3306 is opened (see screenshot)
  • the bind-address line is 0.0.0.0 in the mysqld.cnf file - I even tried to put in it comment - please note my.cnf sends to the mysqld.cnf file.
  • of course for every modification I've restarted the mysql server - and the server itself...
  • no firewall are setup...

enter image description here

I'm on Ubuntu 16.04 LTS, mysql and phpmyadmin are setup on it.

What I'm missing ? Thank you for your help Bastien

Bastien
  • 35
  • 4

1 Answers1

0

After you changed the bind address you restarted with systemctl restart mysql.service, yes?

Here's a very similar situation, try following all of these steps: Remote Connections Mysql Ubuntu

I think the flush privileges step will be a help to you.

Lea Klein
  • 408
  • 2
  • 2