Creating a MySQL Database<\/h2>\n
You can use two different methods to create a MySQL database through cPanel.<\/p>\n
Method 1: Quick Setup Using the MySQL Database Wizard<\/h3>\n\n- On the cPanel homepage, click the “Database Wizard<\/strong>” button under the Databases section.<\/li>\n<\/ul>\n
![\"Database](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Database-Wizard.png\" "\\"Database")
<\/a><\/p>\n\n- On the page that opens, enter the desired database name in the “New Database<\/strong>” field and click the “Next Step<\/strong>” button. (54 characters max.)<\/li>\n<\/ul>\n
![\"New](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/New-Database-Next-Step.png\" "\\"New")
<\/a><\/p>\n\n- On the page that opens, you will be asked to provide some information for the database user. Fill in the fields as follows to proceed with creating the user:\n
\n- Choose a “username<\/strong>” for the user who will connect to the database. (38 characters max.)<\/li>\n
- Enter a strong password in the “Password<\/strong>” field. If you wish, you can use the Password Generator tool to create a secure password.<\/li>\n
- Re-enter the password in the “Password (Again)<\/strong>” field.<\/li>\n<\/ul>\n<\/li>\n
- After filling in the required information, click the “Create User<\/strong>” button.<\/li>\n<\/ul>\n
![\"MySQL](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/MySQL-Create-User.png\" "\\"MySQL")
<\/a><\/p>\n\n- On the privileges screen that opens, select the permissions<\/strong> you want to assign to the user. To grant all privileges, check the “ALL PRIVILEGES<\/strong>” option.<\/li>\n<\/ul>\n
![\"select](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/select-the-permissions.png\" "\\"select")
<\/a><\/p>\n\n- Click the \u201cMake Changes<\/strong>\u201d or \u201cNext Step<\/strong>\u201d button to complete the process. Once completed, your MySQL database and database user will have been created, and the selected privileges will have been assigned to the user.<\/li>\n<\/ul>\n
![\"Make](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Make-Changes.png\" "\\"Make")
<\/a><\/p>\nMethod 2: Manually Creating a MySQL Database and User<\/h3>\n
If you want to create the database and its user separately, follow the steps below.<\/p>\n
\n- On the cPanel homepage, click the \u201cManage My Databases<\/strong>\u201d button under the Databases section.<\/li>\n<\/ul>\n
![\"Manage](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Manage-My-Databases.png\" "\\"Manage")
<\/a><\/p>\n\n- In the \u201cCreate New Database<\/strong>\u201d section, enter a name for your database in the field provided and click the \u201cCreate Database<\/strong>\u201d button.<\/li>\n<\/ul>\n
![\"Create](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Create-New-Database.png\" "\\"Create")
<\/a><\/p>\n\n- Scroll down to the \u201cDatabase Users<\/strong>\u201d section on the same page. Enter the desired username and set a strong password for the user. Then click the \u201cCreate User<\/strong>\u201d button.<\/li>\n<\/ul>\n
![\"Create](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Create-User.png\" "\\"Create")
<\/a><\/p>\n\n- After creating the database and user, go to the \u201cAdd User To Database<\/strong>\u201d section and select the user you created and the corresponding database. Then click the \u201cAdd<\/strong>\u201d button.<\/li>\n<\/ul>\n
![\"Add](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Add-User-To-Database.png\" "\\"Add")
<\/a><\/p>\n\n- On the privileges screen that opens, select the permissions<\/strong> you want to assign to the user. To grant all privileges, check the “ALL PRIVILEGES<\/strong>” option.<\/li>\n<\/ul>\n
<\/a><\/p>\n\n- Click the \u201cMake Changes<\/strong>\u201d or \u201cNext Step<\/strong>\u201d button to complete the process. Once completed, your MySQL database and database user will have been created, and the selected privileges will have been assigned to the user.<\/li>\n<\/ul>\n
<\/a><\/p>\n\nMySQL Database Management<\/h2>\nManaging Databases with phpMyAdmin<\/h3>\n
You can access the database management interface by clicking the “phpMyAdmin<\/strong>” icon on the cPanel homepage. Through phpMyAdmin, you can view database tables, browse, edit, and delete records, and execute SQL queries.<\/p>\n![\"phpMyAdmin\"](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/phpMyAdmin.png\" "\\"phpMyAdmin\\"")
<\/a><\/p>\n![\"phpMyAdmin\"](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/phpMyAdmin2.png\" "\\"phpMyAdmin2\\"")
<\/a><\/p>\nManage My Databases<\/h3>\n
You can perform the following operations by navigating to the \u201cManage My Databases<\/strong>\u201d menu under the Databases section on the cPanel homepage:<\/p>\n\n- Create new databases, view existing databases, rename databases, and delete databases.<\/li>\n
- Create new database users, view existing users, change their passwords, rename them, and delete them.<\/li>\n
- View the users assigned to a database, remove assigned users, add new users to a database, and update user privileges by clicking on the assigned user.<\/li>\n
- Perform database check and repair operations.<\/li>\n<\/ul>\n
If you want to create the database and its user separately, follow the steps below.<\/p>\n You can access the database management interface by clicking the “phpMyAdmin<\/strong>” icon on the cPanel homepage. Through phpMyAdmin, you can view database tables, browse, edit, and delete records, and execute SQL queries.<\/p>\n You can perform the following operations by navigating to the \u201cManage My Databases<\/strong>\u201d menu under the Databases section on the cPanel homepage:<\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n\n
\n
<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\nMethod 2: Manually Creating a MySQL Database and User<\/h3>\n
\n
<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\nMySQL Database Management<\/h2>\n
Managing Databases with phpMyAdmin<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nManage My Databases<\/h3>\n
\n
![\"Database](\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2026\/11\/Database-Backup-and-Restoration.png\" "\\"Database")
<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"