Hello All,

I would like to connect MySQL database from PHP, with help of SSH tunneling. I suppose/want to use "ssh2_connect" and "ssh2_..." sets of commands.

Queries are that can I use these sets of command for this purpose, and if yes how can I do that.

Thanks in advance.

Regards,

Well, to login to your mysql demon from ssh cli you use the following command:

> mysql -u username -p
> password

And you are now able to use the mysqld from ssh. You use "quit" to stop using the server.

But may I ask why you want to do it over ssh?

As for the ssh2_* functions, never used them so I can't help you with that :)

__________________
Nunchaku! Who doesn't like martial arts? =)

Are you sure we cannot able to connect mysql from PHP with the help of ssh2_* ? My main query is based on that. I really would like to know that if this is possible or not ?

Well if you can connect to ssh you should be able to use mysql. But it would be pretty difficult to use compared with the normal mysql functions.

__________________
Nunchaku! Who doesn't like martial arts? =)

this may be of some use: http://chxo.com/be2/20040511_5667.html

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)