In database management systems, it is common practice to rename databases and database usernames as well as to enable and disable username prefixes for a variety of reasons.
1) Security: By making it more difficult for potential attackers to guess system-specific names, renaming databases and usernames can improve security. In addition to hiding system-specific data, disabling username prefixes might make it more difficult for attackers to target certain accounts.
2) Clarity and Organisation: Renaming usernames and databases can aid in keeping the database system’s structure tidy and unambiguous. This can make it easier for administrators to manage and for users to understand large-scale systems with numerous databases and users.
3) Renaming databases and usernames may occasionally be required in order to adhere to legal regulations or industry best practices for database security and administration. This guarantees that the database system complies with industry standards and that sensitive data is appropriately protected.
The specific procedure may differ according to the database management system you’re using (e.g., MySQL, PostgreSQL, SQL Server, etc.), but these are the general procedures to complete these tasks:
Renaming Databases:
1. Backup: To avoid data loss, always begin with a backup of your database.
2.Stop Database Services: In order to stop any active transactions, stop the database service.
3.Rename Database: To rename the database, use the relevant command or tool that your database management system has given.
4.Revisions to Configurations: Update any configuration files or settings mentioning the previous name of the database.
5.Restart Services: In order to take effect, restart the database service.
6.Test: Check to make sure the database with the new name is reachable and operating properly.
The username of the account appears before the database name and username in cPanel. From the WHM panel, you may disable the default configuration that adds the username prefix.
How to Turn Off Username Prefix for Databases and Database Users
1. Use your root account to access the WHM panel.
2. In the search bar, search the Tweak Settings
3. Click on Tweak Settings.
A panel containing numerous setting options will show up.
4. Select the SQL tab.
You can manage SQL-related settings using a variety of options found here.
5. Look for the Require a username prefix on names of new databases and database users option and click on the Off button.
6. Click on Save button.
It allows the WHM panel to disable username prefixes on names for new databases and database users and save configurations.
