(Illustration) mysql client mysqlworkbench in windows connects to the mysql server CentOS on the virtual machine, and the virtual machine installs centos

(Illustration) mysql client mysqlworkbench in windows connects to the mysql server CentOS on the virtual machine, and the virtual machine installs centos

I have installed the mysql server in CentOS Linux and mysql client mysqlworkbench in Windows, therefore, we want to connect the mysql client mysqlworkbench in windows to the mysql server in CentOS on the virtual machine. The entire process is recorded as follows:

1. Install the Mysql WorkBench Client

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

Http://dev.mysql.com/downloads/workbench/ download path

2. You cannot download the workBench installation package only. There is a text section above the download. The prerequisite for the installation is to install the following software:

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

4. Through the above method, a total of four installation packages are obtained, such:

5. installation steps: first install vcredist_x64.exe, and then install the mysql-workbench-community-6.2.5-winx64.msi on OK, the other two can not be needed.

Ii. Install Mysql Server

Run the rpm-qa | grep mysql command in CentOS to check whether the mysql has been installed. If it is not installed, run the yum install mysql command to install it. This information is relatively simple and will not be described.

Iii. mysql client mysqlworkbench in windows links to the mysql server in CentOS on the Virtual Machine

1. Start the mysql server first, for example:

2. view the Server IP address and Port:

3. Check whether the IP address can be pinged in windows:

4. Check whether telnet IP and Port are available in windows.

Win7 need to install telnet service, zip package download decompress can be used directly, tool download path: http://download.csdn.net/download/yuzongtao/8602985

5. Authorize the Client IP address on the mysql server:

-- Assign permissions for root Remote Access
Grant all privileges on *. * to 'root' @ '%' identified by 'root' with grant option;
-- Takes effect
Flush privileges;

 

6. Link error:

7. Disable the Linux Firewall

8. Log in according to the authorized user name and password. The connection is successful.