1. Portal Home
  2. Knowledgebase
  3. Unlimited Hosting
  4. cPanel X3
  5. MySQL
  6. How can I create a MySQL database?

How can I create a MySQL database?

1- Click on the MySQL databases button on the Cpanel home page. 2- Enter the name of the database in the Db field. 3- Click on the Add Db button. The database will be added to the /var/lib/mysql folder. 4- 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.

Related Articles

How can I Remove a database?

Removing a database will delete that database from its online location. Be sure that you have saved a copy of the database if you want to keep any of the information in the database. Removing a...

How can I Create a MySQL user?

You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the specific...

How can I Remove a user?

Removing a user deletes that user - it removes all database permissions that the user has and does not allow that user access to any MySQL databases. 1- Click on the MySQL databases button on...

How can I Grant a user's permissions to a MySQL database?

Once you have created a user to use a database you need to grant that user permission to use the database. 1- Click on the MySQL databases button on the Cpanel home page. 2- Choose the...

How can I Remove a user's permissions?

A user will no longer be able to access a particular database when you have removed their permissions to that database. 1- Click on the MySQL databases button on the home page. 2- Click on...