In Windows, the mysql client accesses the SQL node server of mysql-cluster in Linux.

Source: Internet
Author: User
Tags node server


In Windows, the mysql client accesses the SQL node server of mysql-cluster in Linux. In Windows, if WAMP is installed, the mysql server is also installed, and the mysql client is also installed, the client and server are not separated for installation. If we want to access the SQL node server in the Linux cluster environment through a Windows client, what do we need to pay attention? Deployment of the Cluster Environment www.2cto.com: 55.133 mgm node CentOS5 55.10 data node + SQL node CentOS5 55.9 data node + SQL node CentOS5 mysql configuration file in Linux is my. cnf. In my. in cnf, there are the following paragraphs: All interaction with mysqld must be made via Unix sockets or named pipes. note that using this option without enabling named pipes on Windows (via the "enable-named-pipe" option) will render mysqld useless! We need to add the parameter "enable-named-pipe" under the [mysqld] of the client. But does it mean that the configuration file of the server needs to be modified after this parameter is added: test Plan: 1. assume that windows client 55.134 connects to the SQL node 55.10 through named pipes, and changes it to my. ini file: [mysqld] enable-named-pipe modify 10 my. cnf file: delete: [client] Module 2. assume that Linux client 55.135 connects to SQL node 55.9 over the network and changes it to my. cnf file: [client] port = 3306 socket =/var/lib/mysql. sock 1. to allow other MySQL clients to remotely connect to the SQL node through TCP/IP connection, comment out the following: # sk Ip-networking to allow access by other hosts over the network. 2. you have also granted permissions through mysql: grant all on *. * TO mysql identified by '***'; view mysql. user, which has shown Host | User | Password % mysql * 3810d91_cd9cdc2edd5c87d48d4d778018656c6 test: Run mysql-h root @ *** on mysql 55.133 @***. ***. 55.10-u mysql-p can successfully log on to the database on 55.10. 3. According to the Web server deployment method, you have modified the DNS resolution path and IP address in the/etc/resolv. conf file on 55.10 and 55.9.

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.