How to block root to access ssh to your server (CentOS 5)

1. First open your terminal
2. vi /etc/ssh/sshd_config
3. Find PermitRootLogin yes
4. Change PermitRootLogin no
5. Save and exit
6. Restart your sshd by type /etc/init.d/sshd restart

That's all.

How to give MySql Root Password

As default, Mysql database didn't have any password. For some security reason, you need give the Mysql with a password. This is the way how to give the password to your Mysql database.

1. Go in to Mysql by type mysql

2. Type update user set password=password ('yourpassword') where user='root'; and enter. yourpassword mean enter your own password.

3. Type flush privileges

4. Exit mysql

To test:

1. Go in to Mysql by type mysql -u root -p and enter

2. It promt you to enter the password. Enter you password given before.

3. If you can login with you password, it mean your work is successfully.

Error after install Phpmyadmin

Last day my friend had asked me about the error after install phpmyadmin in his Linux.

The error say
"The configuration file now needs a secret passphrase (blowfish_secret)"

This is the solution:
1. Go to phpmyadmin directory on your linux. Eg: /usr/share/phpmyadmin (in Centos5).

2. File the config.inc.php with your favorite editor eg. vi

3. Find $cfg ['blowfish_secret'] = ' ';

4. Fill in the password or phassphrase, example
$cfg ['blowfish_secret'] = ' 123456';

5. Save and quit the editor. That all