保护远程mysql连接(Securing remote mysql connection)

保护远程mysql连接(Securing remote mysql connection)

我处于不幸的位置，不得不将本地微软访问数据库与远程mysql数据库同步。

我写了一个PHP脚本，它将每10分钟同步一次数据库。 但我绝对关心安全问题。

到目前为止，我已经使用cpanel设置了远程mysql，这只允许我的IP地址建立连接。 我还确保我正在连接的用户具有有限的权限。

但是，我知道我将来回发送的数据将是未加密的。 我能做些什么来确保我的数据是加密的吗？ 我还想知道我的mysql用户名/密码当前是否按照我设置的方式进行加密？

卢卡斯

I'm in the unfortunate position of having to sync a local microsoft access database with a remote mysql database.

I have written a php script which will sync the databases every 10 minutes. However I'm definitely concerned about security.

So far I have set up remote mysql with cpanel, this allows only my I.P address to make connections. I've also made sure the user I'm connecting with has limited permissions.

However, I'm aware that the data I'll be sending back and forth will be unencrypted. Is there anything I can do to make sure my data is encrypted? I'd also like to know whether my mysql username/password is currently encrypted the way I have it set up?

Lucas

最满意答案

您可以使用与MySQL的安全连接：

MySQL方面： http ： //dev.mysql.com/doc/refman/5.5/en/secure-connections.html

PHP方面： http ：//php.net/manual/en/mysqli.real-connect.php（MYSQLI_CLIENT_SSL标志）

我没有使用PHP与MySQL连接到MySQL，但是，我认为在http://php.net，http ： //dev.mysql.com和http://google.com上找到所需的信息并不困难。

更新

这可能会有所帮助： http ： //www.madirish.net/node/244,PHP to MySQL SSL Connections ， http：//www.php.net/manual/en/mysqli.ssl-set.php

You can use secure connection to MySQL:

MySQL side: http://dev.mysql.com/doc/refman/5.5/en/secure-connections.html

PHP side: http://php.net/manual/en/mysqli.real-connect.php (MYSQLI_CLIENT_SSL flag)

I have not worked with SSL connections to MySQL with PHP, but, I think it is not hard to find needed information on http://php.net, http://dev.mysql.com and http://google.com

Update

This may help: http://www.madirish.net/node/244, PHP to MySQL SSL Connections, http://www.php.net/manual/en/mysqli.ssl-set.php