The method of using SSH channel to connect to remote Mysql is as follows:
1. Establish SSH channel
Just type the following command locally :
ssh -fNg -L 3307:127.0.0.1:3306 myuser@remotehost.com
Recommended online learning video tutorial: mysql video tutorial
2. Connect to Mysql
Now, you can connect locally The remote database is just like accessing the local database.
mysql -h 127.0.0.1 -P 3307 -u dbuser -p db
Or use Mysql Query Brower to access the Client's 3307 port.
Similarly, use PHP to access:
<?php $smysql = mysql_connect( "127.0.0.1:3307", "dbuser", "PASS" ); mysql_select_db( "db", $smysql ); ?>
Recommended related articles and tutorials: mysql tutorial
The above is the detailed content of How to use SSH channel to access mysql. For more information, please follow other related articles on the PHP Chinese website!