Trying to make a simple connect to my servers MySQL database and I get
Warning: mysqli_connect(): (HY000/2003): Can't connect to MySQL server on '<host>' (113)
netstat -tulpen has a :3306 record
Proto Recv-Q Send-Q Local Address Foreign Address State User Inode PID/Program name
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 999 801279 32067/mysqld
My bind-address in my.cnf is set to 0.0.0.0
and I still can't manage to connect to a database.
My MySQL users
+------------------+------------------------+
| User | Host |
+------------------+------------------------+
| root | 127.0.0.1 |
| root | localhost |
| root | <ip> |
+------------------+------------------------+
I can connect from the inside of my server.
What i'm missing?
Thank you in advance
the 113 error shows "no route to host" error.you must configure your ip address on both machines.
of course,it must be routable.else, it wont work.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With