I am not able to access mysql /mariadb from another machine please guide how o do that. Error getting ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.0.35' (115)
-
Error :- ERROR 2002 (HY000): Can't connect to MySQL server on '192.168.0.35' (115)
-
Greetings, @Lokesh-Suthar
I would start by making sure that port 3306 is open on the MySQL server. An easy way to do that is to run Nmap.
sudo nmap -n -Pn -p 3306 192.168.0.35
This should return something like...
PORT STATE SERVICE 3306/tcp open mysql
If the STATE says closed then you won't be able to connect using that port. If you changed the listening port, then you'll need to connect using that port.
Another circumstance that might be preventing you from connecting remotely would be that you have the right port enabled, but the MySQL service is connected to an internal IP like 127.0.0.1
You can check that with netstat
netstat -antp
There should be an entry under the
Local Address
column that reads192.168.0.35:3306