All In One Security – Database Settings
Script & Screenshots
In this video I’m going to go through the All In One Security Database Settings.
This is where you’ll find Database Security and Backup options. Your Database is the most important asset of your website because it contains a lot of your site’s information. The database is also a target for hackers. Therefore, this page is important.
To get here, click on WP Security, then Database Security.
There are two tabs, the DB Prefix and the DB Backup. Starting with DB Prefix. One way to add a layer of protection for your database is to change the default WordPress Database prefix from wp underscore to something else. If it’s not wp underscore, then the hackers will have to try to guess what it is, which will make it much more difficult for them.
You have the option of having the system randomly create a new character string for you by checking that box. Or if you want to create your own string, type it in the box below.
I haven’t come across any issues from changing this prefix, but I highly recommend running a backup before changing this setting. It’s better to be safe, just in case.
To run a backup, click over to the DB Backup tab. Then click on the Create DB Backup Now button.
It should display a message stating that the backup was successful. It also shows the location of the backed up file on your ftp server. It will also email it to you if you have that option setup on Scheduled Backups. I’ll show you how to do this later in the video.
Now I’ll go back to the prefix page. I’m going to have it randomly choose a new string.
But really quick, I’m going to show you the database and how it shows the current prefix is wp underscore. Don’t worry, you should never have to go into the database. That is only for advanced users. I mostly want to show you this so you can see how it works.
Once you’ve typed in your prefix name, or selected it to generate one, click on the Change DB Prefix button.
Here it shows it was successful. It changed my prefix to erymj_. This will definitely make it much harder for a hacker to guess.
Now back to the database, after I refresh you can see the database prefixes changed.
Now back to the DB Backup tab. As I showed you earlier, you can run a manual backup at any time by clicking the Create DB Backup Now button.
Below that is the Automated Scheduled Backups option. I recommend setting up Automated Scheduled Backups. Check the box next to enable it. If you don’t make too many changes, the backup interval of every four weeks will be plenty. But if you make daily changes, you might want to increase this to weekly or possibly even daily. If you do daily, make sure you have plenty of hosting space to store them.
For the Number of Backup Files To Keep, I recommend increasing this number if you have the space for it. If your site was to be hacked and you didn’t know right away, it will be overwriting your backups with the hacked version. If you store more files and possibly even move some offsite every once in a while, you’ll have a better chance of having a pre-hacked version of your website to restore.
The last option is to Send Backup File Via Email. I like to check this option so that it will create an offsite backup. This can come in very handy if your site was to ever get hacked. As long as you save these emails. It will default to the email address you have set under General Settings for WordPress, but you can change it to another.
Click on the Save Settings button to save your changes.
That’s it for this video. I’ll see you in the next one.