MySQL Database Engine


The SQL database of choice for most real-world purposes (i.e., for your average database needs). Bit finicky on occasion, but I loathe databases (given the choice, I'd probably use Postgres).

Lockdown in a nutshell:

;/etc/my.cnf
[mysqld]
port=3306
set-variable = key_buffer=8M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
bind-address = 127.0.0.1
DROP DATABASE test;
use mysql;
DELETE FROM db WHERE Db like 'test%';
DELETE FROM user WHERE Host = '%';
DELETE FROM user WHERE User = '';
UPDATE user SET Password = password('mypassword') WHERE User = 'root';
FLUSH PRIVILEGES;