Allow MySQL in the virtual machine to be accessed by the host

1, VirtualBox to Ubuntu system settings, "Network" select "Bridge network card"

2. Install MySQL server

sudo su; Apt-get Intall Mysql-server

3. Grant permission to remote access:

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

Flush privileges;

4. Modify the binding address

VI/ETC/MYSQL/MYSQL.CONF.D/MYSQL.CNF, change bind-address=127.0.0.1 to bind-address=0.0.0.0.

5. Restart the MySQL server

/etc/init.d/mysql stop;

/etc/init.d/mysql start;

Allow MySQL in the virtual machine to be accessed by the host