Skip to content

Connect Navicat to Remote MySQL tunnel script via mysqli for use with PHP 8

Notifications You must be signed in to change notification settings

imseyed/navicat_remote_MySQL

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 

Repository files navigation

navicat remote MySQL connection

26/10/2021 - we updated ntunnel_mysql.php script with Webcy inc. for remote connect to MySQL or MariaDB database by Navicat.

Older version

An older version of this script is available at the @rothkj1022/ntunnel_mysqli. But that version does not support PHP8.

New version

We updated it and it is now available for PHP8 in @imseyed/navicat_remote_MySQL.


Remote MySQL

If you are using a shared host and the remoteSQL is blocked, you will need this script to access the database through navicat. Both versions Navicat Premium 15 and Navicat 15 for MySQL support this script.

About Tunneling

HTTP Tunneling is a method for connecting to a server that uses the same protocol (http(s)://) as a webserver does. It is used while your ISPs do not allow direct connections to database, but allows establishing HTTP connections.

Uploading the Tunneling Script

To set up an HTTP tunnel, first upload the ntunnel_mysqli.php script to your web server.

Setting up HTTP Tunnel

The following instruction guides you through the process of configuring a HTTP connection.

  1. Select the HTTP tab in Navicat and enable Use HTTP Tunnel.
  2. Enter URL of the tunneling script, e.g. http://www.example.com/ntunnel_mysqli.php .
  3. If your server installed a Web Application Firewall, you can check the Encode outgoing query with base64 option.
  4. If the tunneling script is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details in Authentication or Proxy tab.
  5. Navicat host name at the General settings page should be set relatively to the HTTP server which provided by your database hosting company.

About

Connect Navicat to Remote MySQL tunnel script via mysqli for use with PHP 8

Topics

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • PHP 100.0%