MySQL connection problem in virtual machine: Lost connection to MySQL server at ' reading initial communication packet, system error:0 and host is not all Owed to connect MySQL

Environment: The Ubuntu virtual machine is installed in VirtualBox, the network uses NAT mode, and port forwarding is turned on.

There are two problems with accessing MySQL server in a virtual machine from other computers in the LAN:

Lost connection to MySQL server at ' reading initial communication packet, System error:0

And

Host is not a allowed to connect MySQL

1. Fix lost connection to MySQL server at ' reading initial communication packet, System error:0

Modify/ETC/MYSQL/MY.CNF

Note #bind-address = 127.0.0.1

Add Skip-name-resolve to [mysqld]

2. Resolve host is not allowed to connect MySQL

Go to MySQL library:

Grant all privileges on * * to ' root ' @ '% ' identified by ' YourPassword ' with GRANT option;

MySQL connection problem in virtual machine: Lost connection to MySQL server at ' reading initial communication packet, system error:0 and host is not all Owed to connect MySQL