Creating a MySQL database

SQL stands for Structured Query Language. SQL is an international standard in querying and retrieving information from databases. MySQL is essentially an SQL server - it responds to requests for information that are written in SQL. To use a MySQL database, you must first create it, and then add one or more users to it.

Here are the steps:

  1. To access the MySQL Account Maintenance Menu, click on the words MySQL Databases on the main screen of your cPanel interface.
  2. Enter the name of the new database in the blank field next to Db:.
  3. Click on Add Db to create the database.


Troubleshooting: You need to create at least one database user and grant that user permission to use the new database. Refer to Creating a MySQL user and Grant a user's permissions to a MySQL database for more information.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

phpMyAdmin

phpMyAdmin allows you to administrate all of your mySQL databases. To learn more about this tool,...

Adding a MySQL user to a database

Once a MySQL user is created, they will need to be given permission to access any databases that...

Adding a MySQL user

You need to create a MySQL user before that user is able to use the database. This does not...

Removing a MySQL database

Since some of our hosting accounts have MySQL database creation limits, it is recommended to...

Removing a MySQL user

When a MySQL user is no longer deleted, you can remove them to prevent them from having access to...

Powered by WHMCompleteSolution