How do I create a MySQL database?
All shared, reseller, and semi-dedicated hosting plans include unlimited MySQL databases through cPanel.
Creating a MySQL database
Section titled “Creating a MySQL database”-
Log in to cPanel and search for MySQL Databases.
-
Under Create New Database, enter your new database name and click Create Database.
-
Your new database will appear under Current Databases.
Creating a database user
Section titled “Creating a database user”After creating the database, you need to create a user and assign it privileges:
-
On the same MySQL Databases page, scroll to MySQL Users > Add New User.
-
Enter a username and password, then click Create User.
-
Under Add User To Database, select the user and database from the dropdowns and click Add.
-
On the privileges screen, select the permissions the user should have (or check ALL PRIVILEGES) and click Make Changes.