cPanel - MySQL Database Wizard



MySQL Database Wizard is a step by step process to create a MySQL database and user and finally adding the user to access the database.

To use this interface, we will need to open MySQL Database Wizard, which can be found in the database section of cPanel Home, as shown below.

MySQL Database Wizard

Step 1 − Create a New Database by providing a Database Name in the text input, once filled, click Next Step.

Database Wizard

Step 2 − Create Database user by providing a username and Password. Click Create User when done.

Create Database Wizard

Step 3 − Add user to the database by granting all the privileges to the user for accessing and modifying the data. Select ALL PRIVILEGES checkbox and click Next Step, when done.

Add User Database

Step 4 − You will get a success message if everything works fine.

To modify the database created using MySQL Database Wizard, you can always use MySQL Databases interface.

Advertisements