Mysql – thesql proxy socks

MySQLPROXYsocks

Plain and simple, can anyone explain me how to connect to a mysql server through a proxy (socks4/5). Preferable via the mysql command line (although there are no options for that in the client).

If it's not possible through the mysql command line than ANY other method will work.

Best Answer

All you need is to install and configure tsocks (transparent socks). It's available in most if not all linux distibutions. Afterwards you only need to prefix your command with 'tsocks', for example: tsocks mysql -h -P .....

Related Solutions

Ruby – How to update Ruby Gems from behind a Proxy (ISA-NTLM)

For the Windows OS, I used Fiddler to work around the issue.

Install/Run Fiddler from www.fiddler2.com

Run gem:

$ gem install --http-proxy http://localhost:8888 $gem_name

Mysql – Should I use the datetime or timestamp data type in MySQL

Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field.

If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way ("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)") and it is simple to change the format of the value to a UNIX timestamp ("SELECT UNIX_TIMESTAMP(my_datetime)") when you query the record if you want to operate on it with PHP.

Best Answer

Related Solutions

Ruby – How to update Ruby Gems from behind a Proxy (ISA-NTLM)

Mysql – Should I use the datetime or timestamp data type in MySQL

Related Topic