1. MySQL Database
2. MySQL Database Wizard
We are using MySQL Database Wizard tool to create the mysql database, user and its priviliges
- Login to cPanel
- Go to Databases section > click on MySQL Database Wizard
- In the New Database text box, Add the MySQL database name, which you want to create.
You have created a MariaDB/MySQL database named “webodesk_test”.
- In the New User text box, Add the MySQL user name, which you want to create and enter the secure password for user
You have successfully created a MySQL user named “webodesk_randy”.
- In the next step, you need to set correct privileges for MySQL user to access the MySQL database, we shall grant all privileges to be able to mange the database without any restriction,
so click on All Privileges option and click on Make Changes.
- Once you have added the privilegs to the user, user can access the database, then you have successfully added the MySQL user to the database.
