I'm running a mysql server using the following command:
mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables &
My understanding is that this command starts up a mysql server daemon as user root that will listen to all interfaces and allows all users to access all databases. Note that I've used --no-defaults, so there is no config file read by mysql.
I'm trying to connect to the server from a different machine using the command:
mysql -p -u root -h MYSQL_SERVER_IP --port 3310
But I'm getting the following classic error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'MYSQL_SERVER_IP' (111)
I've switched off all rules using 'iptables -F', both in server and client. Also the server is ping-able from client and vice-versa.
What am I missing?