Maximizing the compatibility of your PHP and MySQL-based applications
If you use PHP and MySQL to power your website, you will be pleased to learn that PHP 5.1.5 and MySQL 5.0.24 may already be available, or will be available for you to use soon. For maximum compatibility, the version of PHP installed on your account can be selected from inside of the VDS Manager. If PHP 5 is available for use on your account, you can click the PHP icon in the Install & Manage – Web Development section of your VDS Manager, and then pick PHP 5.1.5 from the drop down. The MySQL 5 configuration has been optimized for maximum compatibility with databases developed under MySQL 3. You can edit the /etc/my.cnf file to disable these compatibility options if needed once MySQL 5 is available for use on your account.

Did you know that you can use NaviCat to manage your MySQL databases?
NaviCat is a popular database management program that runs on your computer, giving you a spreadsheet-like view of your MySQL database contents. You can use NaviCat with your Jumpline VDS account by enabling the SSH Encryption option to secure your connection. When creating the connection inside of NaviCat, enter the following:
Under the general settings tab:
Host name/IP address: yoursitedomain.com
Port: 3306
Username: root
Password: your MySQL password
Under the SSH settings tab:
            Use SSH tunnel: Enabled
            Host name/IP address: yoursitedomain.com
            Port: 22
            Username: your VDS username
Password: your VDS password

Simplify and speed up your database-driven apps with SQLite.
Support for SQLite is now available in PHP 5, giving you another great database to use when developing your applications. This powerful database system is disk-based, as opposed to running as a networked service like MySQL, meaning that your databases are stored in a single file inside of your VDS. Backing up your database is as simple as copying this file to your computer via FTP, and SQLite offers performance that exceeds MySQL for most operations. You can read more about how to get started using SQLite in your PHP applications at http://us2.php.net/manual/en/print/ref.sqlite.php. A good place to start is the sqlite_open command, which creates and accesses SQLite database files.

Want to log in to the command line for your VDS without a password?
If your SSH client supports logging in using SSH keys, you can configure your VDS to allow automatic login to your account without a password. Each SSH client differs in how to enable the use of SSH keys, but all clients should provide you with a “public key”, or a string of random text that is to be kept on the server for authentication. Once your client generates this public key, simply create a new file inside of the /.ssh/ folder on your VDS named authorized_keys, then paste the public key line into that file. Now, when you log in to your VDS, the server will verify that the key on your computer matches they key on the server and you will not be prompted for a password. For more information on generating the “public key” and setting up this type of authentication, refer to the documentation provided with your SSH client.