Awesome
MySQLTunnel
A http MySQL remote tunnel
Local use
Open index.php and put your database params and tunnel.
include 'tunnel.class.php';
$cfg = array('tunnel_url' => 'http://localhost/MySQLTunnel/remote.tunnel.php',
'db_data' => array(
'host' => 'localhost',//default is localhost
'user' => 'YOUR USER',
'pass' => 'YOUR PASS',
'db_name' => 'YOUR DATABASE',
'port' => '3306'));//default mysql port is 3306
$mysql = new Mysql_tunnel_client($cfg);
Write a new query for the database
$query = 'SELECT * FROM characters WHERE level = 85 LIMIT 5';
$q = $mysql->query($query);
Remote Use
Check your ip address and add it in the list of allowed ips in remote.tunnel.php like this.
class Mysql_tunnel_server{
private $db, $link;
public $errors = array();
public $ips = array('127.0.0.1','2.87.9090.244'); //Add here allowed ips
Upload remote.tunnel.php on your domain. Insert the link of remote tunnel
$cfg = array('tunnel_url' => 'http://www.yourdomain.com/MySQLTunnel/remote.tunnel.php',
Have fun!
Security
Databases credential are transmitted via http.
Only if you are on the list of allowed ips you can fetch the query.
Mysql_tunnel_client class
To use mysqltunnel, first we need to include the Mysql_tunnel_client class file, create an array with the database params and then assign the class to a new variable. The $cfg array consists of the following data:
- tunnel_url: the url of the remote tunnel.php file
- db_data
- host: the host of mysql in the remote machine (default is localhost)
- user: username of remote mysql
- pass: password of remote mysql
- db_name: the database name to use
- port: port to connect to mysql database default is 3306