A mysql server with default settings is listening on a port on a machine:
$ nmap -p0-65535 192.168.1.97 Starting Nmap 7.60 ( https://nmap.org ) at 2019-03-20 14:34 EDT Nmap scan report for ocean.fios-router.home (192.168.1.97) Host is up (0.00036s latency). Not shown: 65533 closed ports PORT STATE SERVICE 22/tcp open ssh 3306/tcp open mysql 33060/tcp open mysqlx Nmap done: 1 IP address (1 host up) scanned in 4.50 seconds
I can't connect to the mysql server from another machine:
$ mysql --user=root --host=ocean --password test Enter password: ERROR 1130 (HY000): Host 'olive.fios-router.home' is not allowed to connect to this MySQL server
How shall I understand the two contradictory results?
Did mysql server receive the connection request, but then refuses it?
If it doesn't accept nonlocal connection request, why does it listen on a tcp port?