Using mysql via SSH (php)

Question

Try to connect to remote mysql via ssh2 and php.

$ssh_server='';
$ssh_port='';
$ssh_user='';
$ssh_password='';

$ssh_connection=ssh2_connect($ssh_server, $ssh_port);
$ssh_auth=ssh2_auth_password($ssh_connection, $ssh_user, $ssh_password);
$ssh_tunnel = ssh2_tunnel($ssh_connection, $ssh_server, $ssh_port);

$db_hostname = 'localhost';
$db_database = '';
$db_username = '';
$db_password = '';
$db_port = '3306';

$connection_mysql = new mysqli($db_hostname, $db_username, $db_password, $db_database, $db_port);

Tunnel is ok, but I see, that mysql use my local mysql DB, not remote via SSH. So, how can i use mysql via SSH?

OS windows with WAMP on it.

@Fred-ii- 127.0.0.1 it is like localhost. I try it, but I again trying connect to local db, not remote. I turnoff my local db, but it is not changed anyting. — autumnrustle
– autumnrustle, Commented Feb 23, 2017 at 20:35
Here are a few links you may want to look at stackoverflow.com/q/23658689/1415724 --- stackoverflow.com/q/26880008/1415724 --- stackoverflow.com/q/9294653/1415724 --- stackoverflow.com/q/11061621/1415724 --- quintagroup.com/services/support/tutorials/mysql-windows — Funk Forty Niner
– Funk Forty Niner, Commented Feb 23, 2017 at 20:38

Dimi · Accepted Answer · 2017-02-23 20:50:01Z

1

create private/public key and setup key authentication with ssh(aka passwordless authentication).

then run this code in your php script

shell_exec("ssh -f -L 3307:localhost:3306 [email protected] sleep 10 >> logfile");

then create database connection like:

$pdo = new PDO("mysql:host=$servername;dbname=$dbname;port=3307", $username, $password);

answered Feb 23, 2017 at 20:50

Dimi

1,27711 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dimi Over a year ago

it works if you install cygwin and append cygwin's bin folder to your path variable.

autumnrustle · Accepted Answer · 2017-08-17 08:48:55Z

-1

$ssh_connection = ssh2_connect($ssh_server, $ssh_port);
ssh2_auth_password($ssh_connection, $ssh_user, $ssh_password);
$query="SET CHARACTER SET utf8; use ${db_database}; ${query};";
$query=str_replace('"', '\'', stripslashes($query));
$ssh_query="ssh -L 3307:${ssh_server}:${ssh_port}; echo \"${query}\" | mysql -u ${db_username} -h ${db_hostname} --password=${db_password}";
$result=ssh2_exec($ssh_connection, $ssh_query);

answered Aug 17, 2017 at 8:48

autumnrustle

6832 gold badges12 silver badges23 bronze badges

Collectives™ on Stack Overflow

Using mysql via SSH (php)

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related