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

Source: Internet
Author: User
Tags mysql client

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

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.