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

Source: Internet
Author: User
Tags mysql client

(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.












Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.