To create a MySQL database and user in cPanel, follow these organized steps:
-
Log into cPanel: Access your hosting account via cPanel using your credentials.
-
Locate the MySQL Database Wizard:
- Navigate to the Databases section in cPanel.
- Click on the "MySQL Database Wizard" option.
-
Create the Database:
- Enter a unique database name (e.g.,
myfirstdb).
- Click "Next Step."
-
Set Up the User:
- Provide a username (e.g.,
myfirstuser).
- Create a strong password (e.g.,
P@ssw0rd2023).
- Click "Create User."
-
Assign Privileges:
- Select "All Privileges" to grant full access.
- Click "Next Step."
-
Confirm the Addition:
- After creation, review the Databases section in cPanel.
- Ensure your database (
myfirstdb) and user (myfirstuser) are listed.
-
Secure Your Password:
- Store the password securely using a password manager to avoid forgetting it.
-
Check for Edits:
- If needed, reset the password via cPanel after initial creation.