Articles on: MySQL

How to create a new MySQL database in cPanel

Here are the steps to create a new MySQL database in cPanel for dotCanada.com customers:

Log into your dotCanada.com cPanel account.

In the "Databases" section, click on the "MySQL Databases" icon.

Under the "Create New Database" section, enter a name for your new database in the "New Database" field. It's recommended to use a descriptive name that relates to your website or application.

Once you've entered the database name, scroll down and click the "Create Database" button.
Your new MySQL database has now been created successfully.

Additional Steps:
• To manage your new database, you can assign a user to it by following these steps:

In the "MySQL Databases" section, scroll down to the "Current Databases" area.

Locate your newly created database and click on the "plus" icon next to it.

Enter a username and password for the new user you want to assign to this database.

Click "Create User" to finalize the process.
• For enhanced security, dotCanada.com recommends creating a separate user for each database you create. This way, if one user's credentials are compromised, your other databases remain secure.
• You can also manage your databases directly from the "Current Databases" section, including renaming, repairing, or deleting them as needed.

By following these simple steps, you can easily create and manage MySQL databases through your dotCanada.com cPanel account, providing a solid foundation for your website or application's data storage needs.

Updated on: 19/04/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!