Database Wizard
The MySQL Database Wizard in cPanel simplifies the process of setting up a database. It:
- Creates a MySQL database
- Creates a database user
- Assigns permissions for that user to access and manage the database
It's a quick way to prepare your server for running apps like WordPress that need a database.
MySQL Database Wizard Steps:
Access the Wizard
- Go to: cPanel > MySQL Database Wizard
This tool helps you easily create a database, user, and set permissions in a few steps.
Step 1: Create a Database
- Enter a name for your new database.
- Click Next Step.
This sets up your MySQL database where your site/app data will be stored.
Step 2: Create Database User
- Enter a username and password for the new database user.
- Click Create User.
This user will connect to and interact with the database.
Step 3: Assign Privileges
- Check the box for ALL PRIVILEGES (or choose specific ones).
- Click Next Step.
This grants the user permissions to read, write, and manage the database.
Complete
You’ll see a success message confirming the setup is complete.
You can now use this database and user in your web apps (like WordPress, Joomla, etc.).
