How to manually create a Database for WordPress in cPanel
If you want to install WordPress on your host manually, it is not very difficult.
All you need is access to the administration panel (cPanel) on your host, the latest WordPress download, and an FTP program to upload.
In this video, I show how to create the MySQL database in cPanel.
I assume you can already access cPanel on your Web host. Usually your domain name followed by /cpanel will get you to it. You will need your user name and password.
There are three step to creating the database for WordPress.
- Creating the database
- Creating the user with a password
- Adding the user to the database
It is very important to write down the database name, user, and password.
You will need these later when you add them to the wp_config file before you upload the WordPress files to your server. Make sure you take note of them. You will find that cPanel will add a prefix to your database and user name.
Here is the video:
Let me know if you find this useful and please mark it in your favorite social network.
The next video will cover adding the information to the wp_config file.
Video on how to edit the wp-config.php file for WordPress
Sure wish I would have checked with you with my recent technology issues. I have purposed myself to find an outsource for my woes
Awwww, man! NOW I find you!
How I wish I’d seen this BEFORE I pulled out my hair trying to get my WordPress blog up.
LOL, well, live and learn. Great tutorial, thanks for this!
Making Sales – The way you worded that comment made me think is was spam – had to read it twice. Are you an English major by chance?
Mrs. Mecomber – I’ll have a lot more tutorials like this.
please some one help me i need to know how to transfare my blog form my localhost to a web host …
Inflames – In WordPress, use the export function and export it to your desktop. Once WP is set up on the actual site, you can simply use the import function to transfer it. I have found that images do not transfer and make sure all the posts and pages have been exported and imported before you delete that localhost blog. Import and export are under the Manage tab.
I used to think this was somehow complicated – thank you so much for the informative tutorials.
I laugh at my ignorance, no really! I had Install4Free do it for me before but they got so overworked they don’t offer the free service anymore… That prompted me to figure out how to do it; good thing I happened on your tuts.
Thanks again – I’ll be linking to these tuts in my blog very soon!
It is now very easy to setup a site and database for WordPress. If your web host offers Fantastico through your control panel it will create it all automatically. Just a few clicks and you are done.
frontpage web hostings last blog post..Globat
Is wordpress the best database to use? Do you need to have a wordpress page in order to take advantage of this service?
@Anthony from Outsourcing Sales Services: WordPress is a blogging platform not a database. It uses the MySQL database to work. *sigh* Spammers
I know that you wont believe me, that I was trying to create the database for the word press, but I was unable to create it. Suddenly I found your blog, I found my self very lucky one. I already implement it and its working.
@kristy from sim only deals: Glad I could help.
Thanks so much for posting the video. My provider didn’t offer me getting to the Control Panel (cpanel) through a link. I had to log in and do it. But figured it out when I watched your video and SAW what I was supposed to be looking for. Then it all came together nicely. Thanks so much for an easy to follow video.
@Body and Spirit: Your welcome! Usually, you can get cPanel by using your URL like this: ht tp://yourdomain. com/cpanel.
Just to let you know, I’ll be eventually posting a lot more blogging hints and helps like this on my new blog which will be posted on this site this weekend.
I am just trying to find the easiest, idiot proof way of creating a webpage to view and enter data in one basic table.
.-= Excel Forum´s last blog ..Macro Application =-.
Excellent video. I’ve never setup a database like this through cPanel. Thanks for the information I’ll keep it in mind. I’ve always used the fantastico installer to create and setup a wordpress blog. Takes less than a minute to install that way.
@Josh from Inexpensive Web Design: Fantasico is very fast and easy, but I believe that if you use it some hosts will automatically run WordPress updates, That can break a theme.
Yes, WordPress auto installer should handle installation for you automatically but as far as I am aware it shouldn’t ask you to create tables (name, fields etc). I have installed WordPress several times and never remeber seeing anything like that.
Thats good advice, but im glad that the auto installer is available on all recent hosting accounts i have opened.
I wanted to install WP manually and the most difficult thing is setting the database. wanted to get the solustion from this web, but unluckyly the video is unavailable …. sigh…
@Miss Jelly Gamat: It’s working now.
There is a lot you need to consider and understand before you decide on WordPress as your publishing platform, and if you expect high traffic volumes. Running WordPress on basic shared hosting will not be sufficient for truly high-traffic sites. Nice resources !