/
How to Create a Database Using the Database Wizard

How to Create a Database Using the Database Wizard

Need a database setup quick?  Look no further then cPanel's Database Wizard!  In just a few steps, you can have a Database, along with the Database Username and Password all setup with just a few easy steps!

Procedure

  1. Login to your cPanel account.

  2. Scroll down your cPanel home page until you locate the 'Databases' section, and from there, select the 'MySQL Databases' icon.

 

image-20240710-220212.png

 

  1. Inside the Database Wizard, you will be asked to enter the database name you wish to use. Enter the name of your new database, then select 'Next Step' to continue.

 

image-20240710-220235.png

 

  1. Next will be a menu to enter the database username and password you will create and have assigned to the new database. Make sure the password has a strength of at least 50 and then select 'Create User' when finished.

 

image-20240710-220258.png

 

  1. The final part would be to assign permissions to the Database User. For admin permissions select the 'All Privileges' box, then select 'Next Step' button to finish creating your new database!

 

image-20240710-220415.png

If you don't want to issue full privileges to a user, below are definitions of each individual permission that you can choose which to give a user.

  • Alter - Enables the user to change the structure of database tables.  Is also required to rename, add, or drop tables.

  • Alter Routine - Needed to add or drop stored routines (procedures and functions.)

  • Create - Enables the creation of new Databases and Tables.

  • Create Routine - Needed to create or destroy routines (procedures and functions.)

  • Create Temporary Tables - Enables the creation of temporary tables.

  • Create View - Allows the user to create a view, or replace and existing view.

  • Delete - Allows rows to be deleted from a database.

  • Drop - Allows you to remove existing databases, tables, and views.

  • Event - Lets the user create, drop, view, or alter events from the Event Scheduler.

  • Execute - Required to execute stored routines (procedures and functions.)

  • Index - Lets the user create or drop indexes. This applies to existing tables only.

  • Insert - Allows rows to be inserted into database tables.

  • Lock Tables - Enables the use of the Lock Tables statement to lock tables that have the 'Select' privilege.

  • References - Unused with current MySQL version.

  • Select - Enables the user to select rows from tables of a database.  Also needed for other statements that read common values.

  • Show View - Enables  use of show create view.

  • Trigger - Enables Trigger operations.  Needed for a table to create, drop, or execute triggers for that table.

  • Update - Enables rows to be updated in tables in a database.