MySQL is a popular, modern and fully featured relational database management system. Creating a MySQL database can be a daunting task if you are new to web development. In cPanel, you can easily create a MySQL database.
In this guide, we have explained step-by-step process for creating a MySQL database and set up a username and Password for it using the cPanel Database Wizard.
- Log into cPanel account.
- Under the Databases section and Click on the “MySQL databases Wizard” icon.
- Here you have to enter name of the new database and then click Next Step.
- Now, you have to create a username and password for the database.
- While entering a password , make sure you are using strong password. You can use the Password Generator.
- Once done, click Create User.
- In the next section, you have to decide which privileges the user has.
- If you are a website administrator and are creating a database for yourself to manage, check the All Privileges box at the top of the page.
Note : If you are creating a username for someone else, check the privileges they want. - Then click on Next Step.
- Now you have finished setting up the new MySQL database, created a username and password to manage it, and assigned privileges to that user.
- The final page of the Database Wizard (see below) gives you options to perform several related tasks.
That’s it!! If you have basic knowledge of cPanel’s Interface then you can easily understand above steps. Once you create a database, you need to protect your valuable data. Learn how to easily backup your database with our comprehensive guide on How to Backup a MySQL Database using cPanel