stylish - functional - affordable - successful

Rename WordPress Database For Security

This is a complete list of simple actions to take to –

  • add a new wordpress installation in cpanel
  • rename the wordpress database from wrdp_1 to whatever name you like (usually the nickname of your website)
  • add the appropriate username to that newly named database
  • change the config.php file using your file manager or ftp client
  • further ways to secure your site easily and appropriately

Add WordPress To Your Domain

Go into cPanel and enter Fantastico. Add wordpress installation to the domain you’ve chosen and in several clicks a new database has been created. By default, your new database has a generic name and if you have more than one website in your hosting panel, a more appropriate name can be added so can can easily identify which database you are accessing.

Change WordPress Database Name

Here’s a video that shows how to easily change the name from wrdp_1 to whatever name you like.

If you are confident you’ll understand the quick version, here it is.
Log into phpMyadmin and select the relevant database from the left hand side column. Go to the operations tab to change the database name there. That was easy.

How To Get Access To Your WordPress Database Again

Once you’ve changed the database name there are a couple other tasks you need to complete before you’ll have access to the site again. These are EASY and vital to complete the process.

  • using an ftp client or file manage, find wp-config.php. Open in an appropriate text editor and change “define(‘DB_NAME’, ‘yourwebsite_wrdp1’)” to ‘yourwebsite_newname’
  • go into cpanel and select MySQL Databases. Go down to “Add User To Database” and after selecting the new database name choose the appropriate user that was created automatically by fantastico and click “ADD”. Of course you can change the name of the user as well, but it really isn’t necessary and takes a few extra steps. Make sure the user has full permissions as an admin so you can access the dashboard too.
  • If you do happen to create a new user (which is a great way to change the database password), make sure you delete the old user from the list on bottom of the page.

adding-a-user-to-wordpress-database

The Easy Way To Secure Your Site Further

Plugins make life so much easier. When starting a new installation I always download “iThemes Security” (formerly Better WordPress Security) and use a few simple features right at the beginning. In one click I can –

  • make sure the admin user has been removed or renamed – IMPORTANT
  • change the user with id_1 – IMPORTANT
  • change the database table prefix from wp_ to a random set of digits – USEFUL
  • rename the wp-content directory to whatever I choose – USEFUL ONLY ON NEW INSTALLATIONS

iThemes-security-wordpress-tasks

One Final Security Measure

I like to add extra security measures by using extra features of  iThemes Security OR add another well rated security plugin to my site … but only ever keep one security plugin activated as more than one will most likely conflict and cause issues.

All the best,

Elizabeth

About 

Elizabeth Richardson currently lives on The Gold Coast Of Australia and is a mother, teacher, business developer, author of the International Best Seller 500 Confessions, founder of The Appreciation Space and Get Rid Of Bad Habits - for good! As a teacher she helped many small business owners get started with Build Your Own Websites Classes in South Gippsland and on The Gold Coast. These days Elizabeth enjoys a life of total luxury but still plays as a writer, professional photographer and web designer. Her passion for living, loving and laughing, remains at the forefront of her focus.

Recommended Website Hosting

Get Occasional Email Updates

Enter your email address:

Delivered by FeedBurner

See What Our Sponsor Has To Offer