Hi How do i connect to MySql from another Ubuntu machine. I tried this
mysql -h 'IP' -P 3306 -u test -ptest
I get ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111). then i tried
nmap -sS -O -p 3306 'IP' and it says 3306/tcp closed mysql
But in the MySql machine when i try it with localhost it works
nmap -sS -O -p 3306 localhost it says 3306/tcp open mysql
What am i missing here