我们大家经常要用MYSQL;但是在本地的时候我们好调试,但是到远程了就不好调试了,用PHPADMIN总显得不是很直观,可是如果能有一个像MSSQL2000的管理工具就好了,在没有开3306的端口的远程服务器上也能用就好了,;
现在就给大家分享此经验;
到网上下载一个:NAVICAT 8 ,网上有破解版的,它能实现HTTP通道,也就是你只要上传一个PHP文档就能实现本地管理远程不开3306端口的机子,[^-^如果服务器80端口也不开的话,你就去跳崖算了^-^.]
这样就能实现远程管理:
这是他的帮助文档:
地址在:
http://www.navicat.com/win_manual/HTTP_Tunnel.html
Setting up HTTP Tunnel
The following instruction guides you through the process of configuring a HTTP connection.
Click
or 
choose File -> New Connection to set up the Connection Properties.
Select the HTTP tab and enable Use HTTP Tunnel.
Enter URL of the tunneling script.
If the ntunnel_mysql.php is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details.
Navicat MySQL host name at the General Settings page should be set relatively to the HTTP server in this case. For example: host_of_mysqldatabase shown below is the host address, which provided by your hosting company, of your remote MySQL database.
现在就给大家分享此经验;
到网上下载一个:NAVICAT 8 ,网上有破解版的,它能实现HTTP通道,也就是你只要上传一个PHP文档就能实现本地管理远程不开3306端口的机子,[^-^如果服务器80端口也不开的话,你就去跳崖算了^-^.]
这样就能实现远程管理:
这是他的帮助文档:
地址在:
http://www.navicat.com/win_manual/HTTP_Tunnel.html
Setting up HTTP Tunnel
The following instruction guides you through the process of configuring a HTTP connection.
Click
or choose File -> New Connection to set up the Connection Properties. Select the HTTP tab and enable Use HTTP Tunnel.
Enter URL of the tunneling script.
If the ntunnel_mysql.php is hosted in a password protected server or you have to access internet over a proxy server, you can provide the required authentication details.
Navicat MySQL host name at the General Settings page should be set relatively to the HTTP server in this case. For example: host_of_mysqldatabase shown below is the host address, which provided by your hosting company, of your remote MySQL database.
