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

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.