MYSQL-TOOLS

Comparison of graphical tools for MySQL

Home Articles

Mysql Articles, Using MySQL GUI Tools, MySQL Features



HeidiSQL & HTTP Tunnel - it works!

Print PDF
User Rating: / 57
PoorBest 

HeidiSQL&HTTP Tunnel

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface.

HeidiSQL is good and for someone simply irreplaceable tool for working with databases MySQL. This GUI has everything you need to work with the MySQL database. But HeidiSQL missing important functionality is the connection through the HTTP tunnel.

When you can't connect to the MySQL server directly, for example a firewall blocks the access from all network protocols, except HTTP protocol, you can use HTTP tunneling.

In this article I'll show you how to connect to remote MySQL server using HeidiSQL via HTTP Tunnel.

 

Some details on the HTTPTunnel protocol

Print PDF
User Rating: / 8
PoorBest 

The HTTPTunnel client listens on configured network ports for incoming client connections. Each new client connection triggers the following sequence of actions. The HTTPTunnel client and server will be referred to as the "httpclient" and "httpserver" - the network client and server will be referred to as the "client" and "server":

Http tunnel protocol

 

HTTP Tunnel using GNU HTTPTunnel package

Print PDF
User Rating: / 4
PoorBest 

Http tunnel

HTTPTunnel is a tunneling software that can tunnel network connections through restrictive HTTP proxies over pure HTTP "GET" and "POST" requests.  Configuration of all components is done over a web based GUI.

 

Trigger mysql example. Introduction on Mysql triggers.

Print PDF
User Rating: / 80
PoorBest 

How to do the data validation directly from MySQL? Trigger mysql example.

Data Validation

Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my application nice, clean and very readable, but support for that was only in Oracle and other SQL servers but not in MySQL.

Beginning with version 5 of MySQL the development team has added “triggering” to their SQL server engine, to meet the growing demand of users.

 

But what are triggers ?

A trigger is a database object that is associated with a table and is activated when an event occurs for that table. Can be successfully used for database data validation and any other calculations done directly on the database.

 

MySQL & HTTP Tunnel. Remote access to mysql.

Print PDF
User Rating: / 17
PoorBest 

Connection to MySQL using HTTP-tunneling. Mysql remote access.

MySQL Http tunnel

HTTP Tunneling is a technique by which communications performed using various network protocols are encapsulated using the HTTP protocol, the network protocols in question usually belonging to the TCP/IP family of protocols.

The HTTP protocol therefore acts as a wrapper for a covert channel that the network protocol being tunneled uses to communicate.

 


Page 3 of 4
mysql tools