Grab Your Free 17-Point WordPress Pre-Launch PDF Checklist: https://wplearninglab.com/17-point-wp-pre-launch-checklist-optin-yt/?utm_source=YouTube_Video&utm_medium=Description_Link&utm_term=Description_Link&utm_campaign=YouTube
Download our exclusive 10-Point WP Hardening Checklist: http://bit.ly/10point-wordpress-hardening-checklist
WordPress Table Prefix – How & Why To Change It | WP Learning Lab
In this tutorial I’m going to show you to change your WordPress Table Prefix. There are two ways. One is to make the change in the wp-config.php file when you are installing WordPress.
In the wp-config.php file you will see an area called WordPress Database Table Prefix. You will see wp_ as the value for the table_prefix variable.
That wp_ is standard for all WordPress installations, so if you don’t change that value any hacker and dataminer knows all the table names of used for your website. In certain situations this is a major security risk.
You can change the wp_ to any sequence of numbers and letters (no special characters and it can’t start with an underscore). It’s wise to end the table prefix with an underscore so that you can more easily read the name of the table.
For example, a table that exists in every WordPress sql database is wp_options. That table name is very easy to read. If you don’t use an underscore and that table name becomes i332hrnfeowoptions it’s much more difficult to read.
If you have already installed WordPress you can WordPress change database tables by using the Change DB Prefix plugin.
After you’ve installed and activated this plugin the settings are pretty simple. It pulls in your current database prefix. In the field below it you enter the desired table prefix of your WordPress MySQL database and click Save Changes.
The only thing is, you can only do this once. So make sure you pick a good database prefix that you’re not going to change later. A good one is hard to decipher and/or guess.
I prefer the MASH Method to choose a prefix. I just mash the keyboard and add an underscore at the end.
I hope this information helps you! If you have any questions leave a comment below or ping me @WPLearningLab on Twitter.
If you want more excellent WordPress information check out our website where we post WordPress tutorials daily.
Connect with us:
WP Learning Lab Channel: http://www.youtube.com/subscription_center?add_user=wplearninglab
Google Plus: http://google.com/+Wplearninglab
You are watching: https://youtu.be/nUa7-OHdsxg