Ygtjki

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?

Thanks.

That's because what MySQL does consider as a users. In MySQL You grant privileges to user+host combination written as user@host.

Following each of following examples are is different

GRANT ALL PRIVILEGES ON db.* TO 'user1'@'%';
GRANT ALL PRIVILEGES ON db.* TO 'user1'@'localhost';
GRANT ALL PRIVILEGES ON db.* TO 'user1'@'192.168.1.97';

Each user+host combination can have a different password (… if append IDENTIFIED BY 'your-password';

You can find more examples and better description in MySQL GRANT documentation

Well, it seems that you have duplicated your question instead of editing the original one.

If you have edited bind-address as said at the other question, your service should not listen to other ip address than the one configured on that parameter.

Second, you are not allowed to connect to this server because you need to also provide access at the application level of MySQL.

At the local shell of that remote server, access your mysql prompt and execute the following

`GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';`

You seem to be missing 2 basic things at MySQL: network configuration and application level authorization/permission. I suggest you to study that technology further.

Google it further by ERROR 1130 (HY000): Host is not allowed. You will be surprised that the FIRST RESULT of that search will also lead you to StackExchange. Here: ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL server [duplicate]