One-line shortcut to dump to a compressed file: Dump with stored procedures
Securing MySQL after Installation
If you just installed Linux or, separately, MySQL server, you need to undertake some simple routines to make it a little more secure. The below will set a password for a superuser account, remove anonymous user account and do some…
