Welcome to the SaHost Support Centre
To create a new MySQL database in cPanel, follow these steps:
- Log in to your cPanel account.
- In theย Databasesย section, clickย MySQL Databases.
- Underย Create New Database, enter a name for the database and clickย Create Database.
- Clickย Go Back.
- The new database will appear in theย Current Databasesย table.
You can now create a user for the database and grant them the necessary permissions. To do this, follow these steps:
- Scroll down to theย Add New Userย section.
- Enter a username and password for the user.
- Clickย Add User.
- Underย Assign User to Database, select the database that you created in step 3 and clickย Assign.
- Underย Privileges, select the privileges that you want to grant to the user.
- Clickย Make Changes.
The new user will now be able to access and manage the database that you created.
Here are some additional tips for creating a MySQL database in cPanel:
- Choose a descriptive name for the database. This will help you to identify the database later.
- Use a strong password for the database user.
- Grant the database user only the privileges that they need. This will help to keep your database secure.