MySQLTuner : Suggestions for optimizing your MySQL installation

logo-mysql-110x57

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:

make it…

Nginx – IP based access control

nginx_logo

Introduction Nginx comes with a nifty module that allows us to allow or deny access to directories served by the webserver. The module is named ngx_http_access_module to allow or deny access to IP address. The syntax can look as follows:…

Java Security Settings

java_sun

Introduction With the latest Java updates the security settings has been set at a higher level by default and there are many websites that now experience problems with some older Java applets that no longer works. This is a common…

Samba share your VPS drive

samba-4

The easiest way, not saying it is the best, to copy files in windows is by using  Windows Explorer. You can mount your VPS disk in Windows using the SMB/CIFS protocol, in this guide I will demonstrate this by installing…

Skype Bot

sevabot-256

 Winner of the 2013/2014 Teach something, Win something is Zander who is active on the Lowendspirit forums and did a writeup on his skype bot setup on one of the Lowendspirit boxes. Happy reading! OS: Ubuntu 12.04 64Bit First of…

Writing your own Nagios plugin in PHP

NagiosMonitorIcon

In second place in the 2013/2014 Teach something, Win something contest we find Maarten Kossen, administrator of LowendBox.com. His guide on creating a Nagios plugin in PHP is a follow up on a series of Nagios tutorials Maarten wrote on…

Transparent Proxy Browsing with Squid3

squid

3rd place in the Teach something, Win something contest  goes to Mark Mearns for his SQUID installation script. Mark took 3rd place because of the simplicity he created with this script which will make a great addition in the script…

Auditing login attempts in MySQL

logo-mysql-110x57

How can I audit login attempts in MySQL? If you open your MySQL server to allow connections from locations other then localhost it is important to log all login attempts or at least the failed ones.  In the MySQL Community…

WordPress: Reset forgotten password

wordpress-logo

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…

How to Setup ZNC

znc-logo

This guide was originally written for the Lowendspirit community by Jimmy Chen and he was kind enough to let me repost it here. He only asked me to send some money for Médecins Sans Frontiers (Doctors without Borders). Which I…

Detecting Current Version of MySQL Server

logo-mysql-110x57

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…