I have been searching the web for hours trying to find a solution for allowing remote connections to MySQL on Ubuntu 14.02. I have done everything I have seen that you can do. Every manipulation of bind-address possible, commenting it, changing its value to *
or 0.0.0.0
. I have granted privileges to both root and to a user that I created named admin
, and every time I am getting a 111
error. I just don't understand why it's not working. I have done EVERYTHING I can possibly find via Google with no results.
sudo netstat -plutn | grep -i sql
tcp6 0 0 :::3306 :::* LISTEN 9329/mysqld