window7 download mysql above is troublesome, do not like, so instead of using virtual machine installed Ubuntu system, provide MySQL service.
First step: Download VMware workstation12,
The second step: Download the Ubuntu image, I use a 14.04 mirror, the latest seems to be 16.04
The third step: Install Ubuntu on the virtual machine, using the classic installation Method step-by-step, very simple.
Fourth step: sudo apt-get install mysql-server, installing MySQL service, after installation, sudo service MySQL start, or sudo/etc/init.d/mysql start
Fifth step: Check if MySQL is running properly mysql-u root-pxxx see if you can go to MySQL and create a new user, because root can only be used on this machine, other machines cannot use root to access MySQL
The command is create user ' username ' identified by ' password ', creating a new user, then granting grant all privileges on * * to ' username ', meaning to give the user all permissions in all databases (except Grant)
Sixth step: Confirm that the virtual machine and host are in the same network segment, both are the same gateway.
Seventh step: Turn off the firewall in Ubuntu, sudo ufw disable
Follow the steps and you should be successful.
WINDOW7 accessing the virtual machine in Ubuntu in MySQL