How To Create A Database For Your Website Using cPanel?
August 23rd, 2015 | by Ravi Chahar || 20 Comments |
Now it’s time to know how to create a database for your website? In the previous post, I have explained about doing the backup of the database of your website. But how can your transfer the database if you don’t even have it. to know how to
The first you need to know how to create a MySQL database?
When you to set up a website then it’s important to have a database. And if you want to transfer your website from one host to another then at that time you have to transfer the database too for which you have to create a new database at your new web host.
Its So Simple To Create a WordPress Database :
You may think that its kind of hard to create a MySQL database but let me tell you that it’s very easy to do. Using cPanel is somehow a big thing for tech savvy people. There is nothing you can’t do. And when it comes to create a WordPress database then you just have to follow some steps which I am going to show you in this post.
Steps To Follow :
Step 1:- First thing is you have to login into your cPanel of your web host.
Step 2:- After that search for databases section in which “MySQL Database Wizard” is present. This is the first technical approach when we talk about creating a MySQL database. You have to click at “MySQL Database Wizard” and a new page appears to you.
Step 3:- Now you can see that a box is there in which you can fill the name of your database you want to create. For creating a database name. Fill the name and click at “Next Step”.
Step 4:- Again a new page appears to you where you have to create a new user for your database. You have to fill the name of the user you want to create and after that, there are two other boxes to fill for the password. You can generate a new password with the option shown there or you can add any password of your own.
It is always recommended to use a very strong password for safety purpose. After filling all the information you have to click on “create user” option and your new user is ready.
Step 5:- Now it is the last step to follow and after that, you will not ask how to create a database? There are many options to choose in front of you on this last page. This step is for adding a user to the database. You have to select “All Privileges” and all the options will be selected.
The final thing you need to do is to click on “next step” option and at the next page a message will be shown to you for congratulating you for creating your MySQL database.
Final Words For Creating A New Database
Having a database is the necessary thing for running a website. You can’t run a website without it’s database. You should know how to create a database using cPanel? Importing your old database to your new web host needs to have a new database at that web host for which you have to create a new database.
What do you think about the method described above? Is it easy or hard to follow? Personally, I think when you want to do any work then going step by step is the key point for the completion with accuracy. If you still face any problem then I am here to help you.