How to Create New Database for WordPress? | Create new database is not difficult as you think. If you know the flow how to create it, it is just straightforward. This tutorial very important if you want to transfer your website manually to a new host.
Create a New Database for WordPress
Step 1: Log into your cPanel.
Step 2: Go to Database section and click on MySQL®Databases.
Step 3: Put any database name here. Make sure the database name is related to your web for your reference. After that, click on Create Database button.
You will go directly to this page after click the button. Just click Go Back link to go to the previous page.
Step 4: Now you have a database name. Next, you should create Username for the database. In the same page, scroll down until you see like as the screenshot below. Put your username and secure password. Then click on Create User button.
After that, you will see the successful message like this. Just click on Go Back link to go to the previous page.
Step 5: The next step is, you must add the user to the database. Scroll down and you will see this. Please select User and Database which you have created just now.
Step 6: After you click the Add button, you will direct to compile all privileges page. See more in the screenshot below.
Your new database now successfully created. It ready for you to use it.
Upload Existed Database to New Database
Step 1: Log into your cPanel
Step 2: On the Database section, click on phpMyAdmin
Step 3: Now, you are in the phpMyAdmin area. Choose your database correctly which you have created just now. Click on it.
Step 4: Click on Import tab and choose your database file. Nothing you can do after that. Just wait for success message or failure message. If you receive a success message, you no need to do anything because it already finishes. If you receive a failure message, please contact your host provider.
Conclusion
In this tutorial, you have learned how to create a new database for transfer WordPress site to new host.
If you like this article, then please FOLLOW to our Google+ and Facebook. Do not forget to check our services page for empowering your WordPress. If you find this post outdated or error, please contact us to fix it.
