WindowsServer2008 Configuring MySQL Proxy

WIndowsServer2008 Configuring MySQL Proxy:

1.MYSQL Proxy: http://dev.mysql.com/downloads/mysql-proxy/, select the version of Windows.

2. After decompression, configure the bin directory of the Mysql-proxy folder to the environment variable.

3. When the environment variable is configured, the administrator mode opens the cmd input command: sc create "Proxytonge" displayname= "MySQL proxytonge" start= "Auto" binpath= "Mysql-proxy- -proxy-address=0.0.0.0:3306--proxy-backend-addresses=1.1.1.1:3306 "

--Note that 1.1.1.1:3306 is the IP address of the cloud database

It is also important to note that the CMD command box must be executed, or it will appear

set-content: Could not find the positional formal parameters of the actual parameter "Displayname=mysql Proxy". 4. After the third step of the command to enter, CreateService success, it indicates that the proxy service has been created successfully. 5. Then execute the following command to open the service, turn on the extranet to access the cloud database through the cloud server c:\users\administrator> mysql-proxy--proxy-address=0.0.0.0:3306--  proxy-backend-addresses=1.1.1.1:3306 If the prompt started indicates that the startup service was successful, as follows: The yellow box is the IP of the cloud server. Finally, you can use Navicat for MySQL or other client connectivity tests locally.

WindowsServer2008 Configuring MySQL Proxy