How to Create a MySQL Database on a Server (phpMyAdmin and Pagoda Operation Guide)

When building a website with WordPress, the database is the centerpiece for storing all of the site's content (posts, comments, settings, etc.).View What is MYSQL DatabaseThis section will show you how to create a MySQL database using the Pagoda panel as an example. This section will take the pagoda panel as an example, and teach you to create a MySQL database through phpMyAdmin by hand, the operation is simple and intuitive, even if you have no basic knowledge, you can also easily complete.

What is phpMyAdmin?

phpMyAdmin is a free database management tool that allows you to visually manipulate your MySQL database through a web interface, without having to memorize complex commands. It is one of the most convenient ways to manage databases for novices.

Official website:https://www.phpmyadmin.net/

Most server control panels (including Pagoda) come with phpMyAdmin pre-installed, which you can access directly through the panel.

pre-conditions

Before you begin, make sure you have done the following:

• Server has been purchased and set up (refer to Server purchase and initialization setup）
• Pagoda Panel installed and successfully logged in (login address, account password usually sent via email after server purchase)
• Installed in Pagoda Panel MySQL Database Services(If not installed, you can search and install it in the Pagoda "Software Store")

Step 1: Log in to the Pagoda Panel and locate the database management portal

1. Open your browser and enter your pagoda panel login address (the format is usually:http://你的服务器IP:8888), enter your account password to log in.
2. After logging in, find "Database" on the left menu bar and click to enter the database management page.

Must log in with root + password

Step 2: Create MySQL Database

There are two ways to create a database in the Pagoda panel: directly through the Pagoda interface (recommended for newbies), or through phpMyAdmin. We'll start with the simpler pagoda interface creation method.

1. On the Databases page, click the Add Database button in the upper right corner.
2. In the pop-up window, fill in the following information:
   • database name: It is recommended to use English + number combinations, such as wp_2023(easy to recognize that this is a WordPress database)
   • user ID: can be the same as the database name or customized (e.g. wp_user）
   • cryptographic: Click "Generate" to create a strong password automatically.Be sure to copy and save to notepad(required for subsequent WordPress installations)
   • character set: Default Selection utf8mb4(Support Chinese and special symbols, recommended)
   • authorized host: Default Selection localhost That's all
3. When you are done, click "Submit" and the database will be created automatically.

Step 3: Viewing and managing the database via phpMyAdmin

Once the database has been created, we can check the details via phpMyAdmin to confirm that the database was created successfully.

1. On the Pagoda "Databases" page, find the database you just created and click on the "Manage" button on the right (the icon is the phpMyAdmin logo).
2. The system will automatically jump to the phpMyAdmin interface, where you will see the name of the database you created in the list on the left.
3. Click on the name of the database to see the tables it contains (new databases are empty by default, tables are automatically generated after installing WordPress).

Step 4: Create the database manually via phpMyAdmin (alternative method)

If you want to create the database directly through phpMyAdmin, you can follow the steps below:

1. On the "Database" page of the Pagoda panel, click the "phpMyAdmin" button at the top to log in to the phpMyAdmin interface (by default, use the Pagoda database root account to log in).
2. Click "New" on the left side of phpMyAdmin and fill in the form on the right:
   • Database name: Consistent with the previous rule (e.g. wp_2023）
   • Sorting rules: Selection utf8mb4_general_ci
3. Click "Create" and the database is created.
4. (Optional) Create database users and authorize them:
   • Click "User Accounts" at the top → "Add User Account".
   • Fill in the user name, host (optional) localhost), passwords
   • In "Database Authorization for Users", select the database you just created and check "All Rights".
   • Click "Execute" to complete the authorization

Recording of key information (very important!)

Once the database is created, be sure to record the following information (required for WordPress installation):

• database nameAs wp_2023
• Database User NameAs wp_user
• Database Password: the password you generated (if you forget it, you can reset it by clicking "Reset Password" on the Pagoda Database page)
• Database hosting: Default localhost(Some servers may require a specific address, consult your server provider)

We recommend organizing this information in a notepad and copying and pasting it directly when installing WordPress to avoid hand-typing errors.

Frequently Asked Questions

1. Insufficient Privileges" when creating a database?Cause: Pagoda panel account privileges are insufficient. Solution: Log in to Pagoda with server root privileges, or contact your server vendor for assistance.
2. What if I forget my database password?Go to the Pagoda "Databases" page, find the corresponding database, and click "More" → "Change Password" on the right side to reset and record the new password.
3. phpMyAdmin won't open?It is possible that the MySQL service is not started. Find the installed MySQL in the Pagoda Software Store and click "Restart".

With the above steps, you have successfully created and managed the database required by WordPress. Next, we will learn how to install WordPress and associate this database.