Server

If you installed fcgi and got 403 error when trying to run phpmyadmin, you just need to add one thing and it is to edit /etc/phpmyadmin/apache.conf to add +ExecCGI in the section

Having root user access available is good foundation to have your website(s) or server hijacked. Why well they know username they need to just go through different passwords to try and guess and belive me people do have software and servers doing this so they can gain something out of that theft. Today I just checked my log files and saw some chineese IP's trying to break in. Really what could I do if they do, just cry about it. So first step is remove root user.

So we create new username when logged in as root.

If you are using fcgi and mpm-worker mode with your apache. You will probably need to set some variables to make your drupal sites work. As they have some stupid defaults like 128kb upload limit (really 128 kb today?) and they override your php.ini settings as now PHP is running trough this FCGI, then you need to go to
/etc/apache2/mods-available/fcgid.conf if there is where your FCGID mod is installed and then change conf file. Just add simple line of with your number of bytes

If you are planing to do some optimization for your server, I would recommend to use memcache at least for your drupal admin pages. When installed it will cache some vital tables that will make faster your admin, even if you use boost and static pages for all your content and your visitors, install this module, it is rather easy this days to do it.

More here

http://drupaldump.com/memcache-setting-drupal-7
http://drupaldump.com/installing-and-configuring-memcache

There is some slight change in default settings.php memcached setting for drupal 7, here is the setting you need to add to bottom of your file and you are ready to go.

After reading on many places that drupal should work better with MPM-worker and fcgid I decided to swith my debain to that configuration. For that I had to do the usuall, collect the info around the web and hope for the best. So here goes information about this on Debian Linux.

First we need to install worker and FastCGI

then enable

then some more install

This is more or less what you need

http://library.linode.com/security/sftp-jails

Just add user before with useradd and then add this as on the link before.

I just installed mysql tuner to try and tune mysql,

http://www.ubuntugeek.com/mysqltuner-check-your-mysql-server-performance...

Hopeing it helps with drupal and hogging of apache.

Go to phpmyadmin and start this 2 commands

depending what you need, if you have drush you could also do that with drush.

Trying to locate some directory or file, use

or

to ignore case.