In a previous article I wrote how to create a SSH tunnel with Putty and use it as a proxy to browse the web. That article can be found here and this article will continue on that track and show you how…
Connect to a remote mysql using ssh tunnels
Category: Database
Install VestaCP , Alternative to Virtualmin
VestaCP is another control panel for your VPS , It’s lightweight and user friendly to handle. Minimum requirements are CPU: 768Mhz Ram: 512M HDD: 20Gb OS: RHEL/CentOS 5,6 Features in VestaCP Web Server DNS server Database Server Mail Server FTP Server…
How to Setup ownCloud on Ubuntu
ownCloud is a simple tool to manage your data on your VPS. We all have used Dropbox , Box or Mediafire to store and share our data with our friends, family and with our colleagues. But they all have storage…
MySQLTuner : Suggestions for optimizing your MySQL installation
MySQLTuner is a script that will assess MySQL performance and recommend steps to maximize performance. To install and run MySQLTuner, log in to your VPS as the root user and follow these steps (for CentOS): Download MySQLTuner:
|
1 |
# wget --no-check-certificate https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl |
make it…
WordPress: Reset forgotten password
When installing and running multiple WordPress blogs it is easy to forget the password for one of the accounts used. You are using different login names and passwords for each account now are you? This has happened to me more…
Encrypting a tar or gz (gzip) File with OpenSSL
When you have sensitive data that you need to transmit but want to make it easy to encrypt and decrypt it, use some standard tools to get the job done! When sending sensitive material across the globe, be it via…
Detecting Current Version of MySQL Server
A popular question when troubleshooting database issues is what version of mySQL is installed and used? You can find this information by running a simple command on the mySQL server. Connect to your MySQL engine with your favorite client, why…
Check If String is a Palindrome using mySQL Reverse function
Mr. Pinal Dave (a MS SQL master) had an interesting post today on his blog. The question was if it is possible to see if a string is a palindrome or not. This question was asked to him from a…
Adding security by clearing root passwords in Solus on an interval
Following in the footstep of a Solusvm database leak in November 2012, Damian Harouff from IPXcore LLC decided that it was time to make some changes to their database if something like that would happen to them. The Solusvm database…
Basic MySQL commands explained
Many of us use mySQL on our dedicated and virtual servers but not everyone knows more then that it’s a database server. This guide will cover some of the basic tasks that you can do from your SSH terminal and…