MySQL client mysqlworkbench link virtual machine on a CentOS MySQL server (illustrated) under Windows

I installed a MySQL server on a virtual machine on a CentOS Linux environment and installed MySQL client mysqlworkbench under local Windows , So just to let the MySQL client under Windows mysqlworkbench link the CentOS MySQL server on the virtual machine, the entire process is logged as follows:

First, install the client MySQL WorkBench

1. Download the installation package: Mysql-workbench-community-6.2.5-winx64.msi

Download path: http://dev.mysql.com/downloads/workbench/

2. Just Download the Workbench installation package is not possible, the download is also a paragraph above the text, the prerequisite for installation is to install the following software:

3. I downloaded only the three software under Visual C + + Redistributable for Visual Studio 2013:

4. Through the above approach, a total of four installation packages, such as:

5. Installation steps: Just install Vcredist_x64.exe first, then install Mysql-workbench-community-6.2.5-winx64.msi OK, the other two can not be required.

Second, install the MySQL server

Using Rpm-qa under CentOS | grep mysql command to see if it is installed, not installed with the Yum install MySQL command installation, this information is more, more simple, no longer described.

Third, the MySQL client under Windows Mysqlworkbench links the virtual machine on the CentOS MySQL server

1. Start the MySQL server first, such as:

2. View server IP, Port:

3.windows to see if you can ping the IP:

4.windows to see if you can telnet through IP, Port

Win7 need to install Telnet service, zip package download After the decompression can be used directly, the tool download path: http://download.csdn.net/download/yuzongtao/8602985

5. On the MySQL server side to the client IP authorization:

--Assign permissions, root remote access
Grant all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT option;
-Effective
FLUSH privileges;

6. Then the link error:

7. Turn off the Linux firewall

8. Login with the authorized username and password, the link is successful.

MySQL client mysqlworkbench link virtual machine on a CentOS MySQL server (illustrated) under Windows