Bill: navicat MySQL database connected to server via HTTP

First, go to the Navicat official website to download the latest version of Navicat. When the installation is complete, open Navicat as shown in:

Then click on the connection in the upper left corner to bring up the new key connection information as shown in:

Complete localhost in the hostname IP address.

The user name and password column will fill in your database username and password.

You cannot connect to the database at this time, and you need to connect to the database via the HTTP channel.

Click HTTP in the Connection Properties tab bar, as shown in:

After checking the use of the HTTP channel, enter your URL and background file address in the Channel address field.

For example: http://www.google.cn/database.php, here is a description of the channel address, the first half: http://www.google.cn/refers to the domain name of your server, Second half: database.php refers to the Navicat client backend connection address. Here database.php can be renamed according to your own preference. So, where does this database.php file look?

After you click OK to save the connection information, this database.php file will automatically generate a php file in the root directory of the Navicat file, but it is not a database.php file, but a unified name for the ntunnel_mysql.php file, as shown in:

We can modify the background file of the HTTP channel that we just connected to the host by renaming it.

After renaming the file, we use the FLASHFXP tool to upload the file to our site's root directory. Then test it to see:

The process is a bit slow, because he wants to connect to the Web server via PHP files and to return the information so you need to wait a minute.

is a successful connection to the MySQL database where the site resides.

Note:

URL: www.google.cn is the instance virtual URL.

Once you've configured your connection information, don't forget to upload the php file in the Navicat file directory to your Web site root directory.

Upload to the root directory of the Web site Navicat generated PHP files must be the same as the file name of your connection information, otherwise it is not connected.

Bill: navicat MySQL database connected to server via HTTP (go)