Skip to content

Daily Archives: November 6th, 2009

How can I tunnel a local MySQL server through SSH?

06-Nov-09

Setting up the Tunnel The most common methods of setting up a tunnel are through putty or through command-line SSH. To open an SSH tunnel via the command line, run: ssh -L3307:127.0.0.1:3306 -p 22 -N -t -x user@myhost.com Connecting with MySQL You can connect to the MySQL server! You want to choose 3307 for your [...]

How to configure to use RPMforge ?

06-Nov-09

How to configure to use RPMforge ? Reference: http://dag.wieers.com/rpm/FAQ.php#B2 It’s very easy. Just install the latest rpmforge-release package for your distribution and architecture. This will automatically install the configuration and GPG keys that are for safely installing RPMforge packages. The configuration of Yum is inside the rpmforge-release package. You need to install it yourself. If [...]

How to change the time zone within a php script

06-Nov-09

How to change the time zone within a php script You can change the time zone within a php script. Here is a sample code: You can set the timezone in .htaccess as well. Add the line: SetEnv TZ America/Indianapolis List of timezones is here: http://us.php.net/manual/en/timezones.php