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

In Windows, if you have installed the WAMP package, the mysql server is also installed, and the mysql client is also installed without separating the client from the server.

In Windows, if you have installed the WAMP package, the mysql server is also installed, and the mysql client is also installed without separating the client from the server.

In Windows, if you have installed the WAMP package, the mysql server is also installed, and the mysql client is also installed without separating the client from the server. 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?

Cluster Environment deployment:

55.133 mgm node CentOS5

55.10 data node + SQL node CentOS5

55.9 data node + SQL node CentOS5

The mysql configuration file in Linux is my. cnf. In my. 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 SQL node 55.10 through named pipes

Modify the my. ini file on MySQL 133: [mysqld] enable-named-pipe

Modify my. cnf file on 10: delete: [client] Module

2. Assume that Linux client 55.135 connects to SQL node 55.9 over the network

Modify the my. cnf file on 10:

[Client]

Port = 3306

Socket =/var/lib/mysql. sock

1. To enable the SQL node to allow other MySQL clients to remotely connect to the SQL node through TCP/IP connection, comment out: # skip-networking, so that other hosts can access the node over the network.

2. You have also granted permissions through mysql: grant all on *. * TO mysql identified by '***'. Check mysql. user, which has shown:

Host | User | Password

% Mysql * 3810d9rjcd9cdc2edd5c87d48d4d778018656c6

Test: On mysql 55.133, run the command: mysql-h root @ ***. ***. 55.10-u mysql-p to successfully log on to the database on mysql 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.