If you want to create a MySQL database for your website or project, you can easily do this via cPanel. In this guide, we will explain step by step how to create a database and log in to phpMyAdmin. You can also find the YouTube video we have prepared below to visually follow the steps.
Related video:
Creating a MySQL Database and phpMyAdmin Login via cPanel
1. Log in to cPanel
First, log in to your account via the cPanel link provided by your hosting company. It is usually in the form of yourdomain.com:2083
.
2. Enter the Databases Section
On the cPanel main screen, you can continue with one of the following options under the "Databases" heading:
-
Database Wizard (Recommended)
-
MySQL Databases (For those who want to do manual operations)
3. Creating a Database with the Database Wizard
You can use the Database Wizard to easily create a database step by step:
Step 1: Determine the Database Name
Enter a new database name and click the "Next" button.
Step 2: Create a User
Specify a username and a strong password to access the database.
Step 3: Assign Permissions
Give the user ALL PRIVILEGES and complete the process.
4. Accessing the Database via phpMyAdmin
After creating your database, you can easily access it via the phpMyAdmin interface and create tables, run SQL queries.
-
Click the phpMyAdmin icon on the main page.
-
Select the database you created in the left menu.
-
You can perform operations such as adding tables, entering data, and backing up from here.
5. Alternative: Manual MySQL Database Creation
If you don't want to use the wizard:
-
Enter the MySQL Databases menu.
-
Create a new database.
-
Create a user and grant permissions to the database.