Sunday, 15 February 2009

MySQL on localhost

sirrma.bppt.go.id that's meant for disaster mitigation site (and is short of Sistem Reduksi Risiko Multi Bencana) is on. Time to restrict the database server!

Here's the clue when you require to do so:

To make mysql listen only on the localhost interface, add the following to each of the three sections in /etc/my.cnf (googled reference)




bind-address = 127.0.0.1


Or control from within phpmyadmin's .htaccess:




hostOrder deny,allow
Deny from all
Allow from localhost


No comments:

Post a Comment