Creating a MySQL database

Overview

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.

 

Steps

1 To access the MySQL Account Maintenance Menu, click on the  mysql icon 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 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Related Articles

Adding email accounts

Overview You have the ability to add extra email accounts to your main account. The number of...

Creating email auto responses

Overview You can use autoresponders to send a message back automatically to anyone who sends an...

Installing WordPress From Your Control Panel

This tutorial is designed to show you how to use Softaculous to install a WordPress application...

Grant a user's permissions to a MySQL database

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