Procedure for using navicat to remotely access MySQL

Procedure for using navicat to remotely access MySQL

1. Modify remote access permissions

// Enter the MySQL server or use other tools

XXXX @ Ubuntu:/$ mysql-H localhost-u root-P xxxx

// Grant data access permissions to any host

Mysql> grant all privileges on database name. * to xxxx @ "%" identified by "password ";

// Make the modification take effect

Mysql> flush privileges

2. Upload the ntunnel_mysql.php file under the navicat installation directory to the Web server directory.

3,Create a navicat connection

1) enter the host name, IP address, user name, and password for general items. (You only need to enter the user name and password)

2) in the HTTP connection, select "Use http channel"

3) Fill in the channel address: http://X.X.X.X/ntunnel_mysql.php

4) Select password for verification (enter the user name and password)

Follow these steps to connect