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.
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
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,