Most dynamic websites (like WordPress) need a database to store content. Here is how to manage them in cPanel.
Creating a Database and User:
-
Log in to cPanel.
-
In the "Databases" section, click on "MySQL Databases."
-
Create a Database:
-
Under "Create New Database," enter a name.
-
Click "Create Database."
-
-
Create a User:
-
Scroll down to "MySQL Users."
-
Enter a username and a strong password (use the Password Generator).
-
Click "Create User."
-
-
Add User to Database:
-
Scroll down to "Add User to Database."
-
Select the user and database you just created.
-
Click "Add."
-
-
Set Privileges:
-
Check "ALL PRIVILEGES" (for a standard website).
-
Click "Make Changes."
-
Checking Database Usage:
-
On the main "MySQL Databases" page, you can see a list of your databases and how much space they are using.
Repairing or Checking Databases:
-
Scroll to the bottom of the "MySQL Databases" page to the "Modify Databases" section. You can check or repair a database if you suspect corruption.
