Portal Home > Knowledgebase > Cpanel > How to create a MYSQL database via cPanel?
Databases offer a method you can use to manage large amounts of information easily over the web. They are necessary to run many web-based applications such as bulletin boards, content management systems, and online retail shops.
If you need to create a database as well as the account that will access it, we recommend that you use the “MySQL Database Wizard”. Alternatively, you may create a database, add users, and link a database to an existing user account with this screen.
You can create a database by logging into your Yournic control panel.
To create the database:
1- In the “New Database” field, type a name for the database.
2- Click “Create Database”.
3- Click “Go Back”.You have now successfully created a database in Cpanel. The new database will appear in the Current Databases table.
Scroll down
After you create the database, you will need to add users and their privileges so that the database can be filled and managed. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.
Let’s learn how to add database users and their privileges
To create a database username and password, please perform the following steps
1- To quickly access the MySQL Users interface by clicking on “MySQL® Databases” under “Databases” section and click “Jump to MySQL Users”.
2- Under “Add New User” please enter a username to be added to your database here
3- Enter a database password in the “Password field”.Important Notes
The password must be 7 letters or shorter.
For help generating a strong password, click the Password Generator button4- Retype the password in the “Password (Again) field”.
5- Click “Create User”.You have now successfully created the username and password for your database.
How do I define a user’s privileges?
Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.
To define a user’s privileges:
1- To quickly access the MySQL Users interface by clickin on “MySQL® Databases” under “Databases” section
2- Under “Add User to Database”, select a user from the User “drop-down menu”.
3- From the “Database drop-down menu”, select the database to which you wish to allow the user access.
4- Click “Add”.
5- From the MySQL Account Maintenance screen, select the privileges you wish to grant the user, or select “ALL PRIVILEGES”.
6- Click “Make Changes”.That’s it!
You can also modify a user’s privileges from MySQL Users interface panel.
Add to Favourites 
Print this Article
