By default, WordPress database table prefix is wp_.
WordPress is open source and everybody in the world knows about it.
This information works for the advantage of hackers. They can do automated SQL injection attacks on database.
To avoid, update WordPress database table prefix from wp_ to something random, unique, and meaningless. So it cannot be guessed easily.
Examples of WordPress Database Table Prefixes
WordPress database table prefix can only contain letters, numbers and underscores.
It’s not necessary that WordPress database table prefix start with wp_.
But it should end with an underscore.
Do not use these sample prefixes on live WordPress production blog’s.
Steps to Change WordPress Database Table Prefix
Follow this method only if you have already installed WordPress.
- Deactivate all your plugins.
- Go to phpmyadmin and Select your database.
- Go to Export – select export method “Quick”, format “SQL” and download.
- Create a copy of file for backup, in case things don’t work out as required.
- Open file in a text editor.
- Find and replace wp_ to wp_mh46eu_ and save.
- Drop all tables from your database.
- Go to Import – upload file, select format “SQL”
- Open wp-config.php file in your home directory on your server.
- Find and replace wp_ to wp_X5w4J9w3t8_ and save.
- Now, re-activate all your plugins.
If you have not already installed WordPress, simply change the prefix during WordPress installation wizard.
If you want to Change WordPress Database Table Prefix on your site.