Naming your databases allows you to determine which database is for which site. Aside from that, it is also an added protection from hackers. Here are the simple steps how to do this.
Change Your WordPress Database Name in 3 Simple Steps
Your WordPress database holds all of your site’s important information, so keeping it safe and organized isn’t something that should be neglected.
Naming your database in a descriptive way can help you more easily keep track of your site and help prevent you from making unintended changes when you can’t tell your databases apart. It also helps protect your site by making it more difficult for hackers to identify and access your database details.
It’s easy to change your database from a default name like db_wordpress123 to db_mysite and it can be done in about five minutes. In this Weekend WordPress Project, I’ll show you how to change the end of your database name to something more recognizable to you, while also being less guessable for hackers.
Edit Your Database
Head over to phpMyAdmin. In cPanel, you can access it through the Databases section of the home page. Once there, select your database from the menu on the left, then click the Operations tab at the top.
Under Rename database to, enter the name you would like to see for your database in the text field and click Go on the bottom, right corner of field. You will be prompted with a pop-up to accept the change.
You will be creating a new database with your chosen name, dropping the tables in your original, then importing those tables to your new database. Click OK to continue with these changes.
Click here for the next steps.