Discover 16 Posts with “security” Tag.
After installing MySQL, it's important that you secure the installation by a) removing anonymous accounts and b) setting a password on the admin account. This can be done with mysqladmin or with direct SQL queries. I prefer the SQL queries so that's what I'll show here. Start mysql command line
I've been bad. Until recently I haven't been backing up my MySQL database. Bad things could have happened. About a month ago I hacked up a simple script to run from cron that will automatically dump, gzip, encrypt using my key gpg (I wrote an extensive post on gpg which