Can I change the name of a MySQL database?
The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a "_" sign and the actual database name.
For example, if your cPanel username is user and you create a database db, the database name will be user_db.
If you wish to rename the database called user_db to user_joom, you should go to cPanel -> MySQL Databases and navigate to the "Rename" button next to the corresponding database.
If you wish to change the whole name of a database user_db, two changes should be made – the cPanel username and the database name.
In order for a cPanel username to be changed, we have to terminate the account and recreate it anew with the new username. This means you will lose all the data stored on the hosting account, like files, email addresses, MySQL databases, forwarders, etc.
Bear in mind that the new cPanel username should not exist and that there is a cPanel restriction of maximum 8 characters long db prefix.
Still, due to the reason that you will lose all the data stored on the hosting account, like files, email addresses, MySQL databases, forwarders, etc., the cPanel username change is not recommended.
cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!