許多時候當要使用mysql時，會遇到如下情況：
1. 信息比較重要，希望通信被加密。
2. 一些端口，比如3306端口，被路由器禁用。
對第一個問題的一個比較直接的解決辦法就是更改mysql的代碼，或者是使用一些證書，不過這種辦法顯然不是很簡單。
相關學習視頻教程推薦：mysql視頻教程
這里要介紹另外一種方法，就是利用SSH通道來連接遠程的Mysql，方法相當簡單。
一、建立SSH通道
只需要在本地鍵入如下命令：
ssh?-fNg?-L?3307:127.0.0.1:3306?myuser@remotehost.com The?command?tells?ssh?to?log?in?to?remotehost.com?as?myuser,?go?into?the?background?(-f)?and?not?execute?any?remote?command?(-N),?and?set?up?port-forwarding?(-L?localport:localhost:remoteport?).?In?this?case,?we?forward?port?3307?on?localhost?to?port?3306?on?remotehost.com.
二、連接Mysql
現在，你就可以通過本地連接遠程的數據庫了，就像訪問本地的數據庫一樣。
mysql?-h?127.0.0.1?-P?3307?-u?dbuser?-p?db The?command?tells?the?local?MySQL?client?to?connect?to?localhost?port?3307?(which?is?forwarded?via?ssh?to?remotehost.com:3306).?The?exchange?of?data?between?client?and?server?is?now?sent?over?the?encrypted?ssh?connection.
或者用Mysql Query Brower來訪問Client的3307端口。
類似的，用PHP訪問：
<?php $smysql = mysql_connect( "127.0.0.1:3307", "dbuser", "PASS" ); mysql_select_db( "db", $smysql ); ?> Making?It?A?Daemon A?quick?and?dirty?way?to?make?sure?the?connection?runs?on?startup?and?respawns?on?failure?is?to?add?it?to?/etc/inittab?and?have?the?init?process?(the,?uh,?kernel)?keep?it?going. Add?the?following?to?/etc/inittab?on?each?client: sm:345:respawn:/usr/bin/ssh?-Ng?-L?3307:127.0.0.1:3306?myuser@remotehost.com And?that?should?be?all?you?need?to?do.?Send?init?the?HUP?signal?(?kill?-HUP?1?)?to?make?it?reload?the?configuration.?To?turn?it?off,?comment?out?the?line?and?HUP?init?again.
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
