You finished the development phase of your Web project, and you
are now heading to production. This means that your web-site will
be soon on-line, visible on the Internet, and may become a
potential target for attacks.
During development, you have been using MySQL on your laptop, and
since you are the only one accessing your laptop you used the
default configuration as-is. You are perfectly right in doing
that, in fact MySQL is pretty secure by default, but here are a
set of post-installation best practices to bring MySQL security
to the next level.
1) Set a password for the root account. Note that by "root
account" I don't mean the super-user of the operating system, but
the super-user of MySQL itself:
$ mysql -u root mysql
mysql> SET PASSWORD FOR
root@localhost=PASSWORD('new_password');
2) If they exist, remove the MySQL anonymous account - or
assign a password to it - and …
[Read more]