Can I change the name of a MySQL database?
Author: admin admin Reference Number: AA-00337 Views: 13606 Created: 2013-04-11 13:05 Last Updated: 2013-04-11 13:05 0 Rating/ Voters

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 first create the new database, then import the old database in it and finally add the user to the new database. You can create the new database and assign a database username to it through the cPanel -> MySQL databases tool. After that you can use the cPanel -> phpMyAdmin tool to import 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 it should be maximum 8 characters long. This also means you will lose all the data stored on the hosting account, like files, email addresses, MySQL databases, forwarders, etc. This is why it is not recommended to change your cPanel username.

Quick Jump Menu