Friday, 7 September 2012

Reset mysql forgotten password

›
First of all you will need to ensure that your database is stopped: root@steve:~# /etc/init.d/mysql stop Now you should start up the da...
Friday, 31 August 2012

apache downloads php in the browser

›
I see this problem in Debian 6. To fix just add the missing library: apt-get install libapache2-mod-php5 and restart apache.
Monday, 30 July 2012

Grant mysql permission

›
CREATE DATABASE mydb; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON mydb.* TO 'myuser'@'localhost' IDE...
Monday, 23 July 2012

iptables rules to counter common attacks

›
# Reject spoofed packets iptables -A INPUT -s 10.0.0.0/8 -j DROP iptables -A INPUT -s 169.254.0.0/16 -j DROP iptables -A INPUT -s 172...
Monday, 16 July 2012

›
Mysql 4+ has a feature known as query cache. Here mysql caches the result set. So suppose a query is run and it takes 5 seconds to run and q...
Saturday, 7 July 2012

Iptables block common attacks

›
Following list summaries the common attack on any type of Linux computer: Syn-flood protection In this attack system is floods with a ...
Saturday, 23 June 2012

memcached on Debian for use with Drupal

›
1. Install  memcached  on your server. Open the Terminal Window and enter : apt-get install memcached libmemcached-tools 2. Instal...
Monday, 11 June 2012

Convert Mysql enginge from Innodb to MyISAM

›
#!/bin/sh DBNAME="DBName" DBUSER="root" DBPWD="YourPassword" for t in $(mysql -u$DBUSER -p$DBPWD --batch --col...
Wednesday, 23 May 2012

nginx php5-fpm on debian 6

›
First add the dotdeb repo to your sources.list file: Code: nano /etc/apt/sources.list add this to the bottom of the file: Cod...
Monday, 9 January 2012

Optimized my.cnf (for 16G memory)

›
#After A LOT of customization headaches here is the config that works pretty well on my server #This may not be the most optimized but is d...