• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • About
  • Blog
  • Contact
  • Right Mindset
  • Learning The Ropes
  • Market Research
  • Email Marketing

AffiliateXFiles

Affiliate Marketing Training And Strategies

  • Affiliate Marketing
    • Affiliate FAQ
    • Affiliate Programs
    • Affiliate Marketing Products
    • Affiliate Marketing Software
  • Market Research
    • Article Marketing
    • Email Marketing
    • Copywriting
    • Domain Name
  • Blogging
    • WordPress Plugins
    • WordPress Tutorials
  • Social Networking
    • Facebook
    • Social Media

How to Create a WordPress Database Manually

October 21, 2012 By Ron Leave a Comment

By now your files should have finished uploading from our previous tutorial how to install WordPress manually using FTP, and you have logged into Cpanel so I can show you how to create a WordPress database manually.

Whether you’re using Cpanel, or whether you’re using Plesk, or any other type of web hosting panel; the key here is to create a MySQL database and username and password.

How To Create A WordPress Database Manually

I am using Cpanel in this tutorial so what you need to do is log-in to Cpanel and scroll down and find where it says “MySQL Database Wizard”, it will be under the Database Tab.

mySQL Database Wizard

Again, if you’re using Plesk or any other type of web hosting panel, you should see something that says “Create MySQL Database” and if you don’t – you can always contact your web hosting company to find out the steps to create one or have them do it for you.

Create Database

In the screenshot above I will enter “member” as the database name as this will help me later to remember which database is associated with each site. Click on next step.

database password

We’ll  generate a password and make sure you save that password is somewhere safe. The next step is to click on Create user and make sure that you keep this information straight away.

Click on “All Privileges” Click on next step and there we go.

create dataase user

Remember you need to make a note of all the database details. You can do this by copying everything over to notepad, the database name, username and password.

Close Cpanel and head back to Filezilla.

Now what you need to do is go back to your computer where the WordPress files are located, and locate the wp-config-sample.php file in the extracted folder.

rename config file

Rename this file to wp-config.php

Next, Right-click and open the config.php file using Notepad. And if you’re using Macintosh – just open this up with your default text editor.

What we want to do is take the three pieces of information that we created earlier: the Database, the Database Username and Password, and replace this information in the newly created config.php file.

OK, now replace the text between these single quotes with the information in the wp-config.php file.

sample wordpress config file

Then you just save and exit.

Now, copy this new file (wp-config.php) over to your website using FileZilla, to the same place where you uploaded your WordPress files.

Once that’s done, let’s get your WordPress site installed, open your web browser, go to the location where you installed the files -> www.YourDomain.com or www.YourDomain.com/subdirectory – this is where the WordPress files are located.

If everything went to plan you should be presented with a welcome screen in the example below.

wordpress install

Enter your site title, and we’re gonna call this “Affiliate X Files Members”. Enter your administrative username and password. Enter your e-mail.

Make sure the box above the WordPress install button is checked, or your site will be blocked from being found by the search engines. So in other words, once you’ve installed your WordPress site if this is checked, it will notify Google that your site is up.

However, you might consider leaving it unchecked at the start until you have time to place some relevant content for the search engines to index. If you leave it unchecked, you will have to remember to change this later in your Dashboard once you have some content posted.

dashoard privacy settings

Click Install WordPress, and it’s done! Now you’re ready to log-in and start posting.

Congratulations you have just discovered how to create a WordPress database manually, you have just installed WordPress 3.4.2 version!

Tweet1
Reddit
Share
Share
1 Shares

Filed Under: Blogging, Wordpress Tutorials Tagged With: market research, wordpress, wordpress blogging

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Ron Cripps the author of AffiliateXFiles has been online since 2001 full time firstly starting his own business selling e-books.

Ron is dedicated to providing as much information to new affiliates so that they can start their own business online, please join our Affiliate Newsletter. Read More…

Subscribe To Our Site!

Want To Learn More About WordPress? Enter Your Email Below.

Thanks, you will get all the information you need as we add new content.

How To Delete WordPress Using Cpanel and Fantastico

How To Clean Up Your New WordPress Blog

How To Install WordPress Manually Using FTP

How to install WordPress using Cpanel and Fantastico

WordPress Themes & Plugins

Author Pro Child Theme
StudioPress Premium WordPress Themes
social warfare plugin

Footer

Stuff To Check Out

  • About Ron Cripps
  • Submit A Guest Post
  • Comment Policy
  • External Links Policy
  • Advertise
  • Get Connected With Affiliate X Files
  • Sitemap

Recent Posts

  • Trudy Seeger on 9 Ways of Using Social Media to Lead Your Business Toward Success!
  • Isabel Anguiano on YouTube: Best Practices to Increase Views
  • Alexander Alison on YouTube: Best Practices to Increase Views
  • Eadlyn Schreave on 7 Godly Tips To Increase YouTube Views
  • RonGc on YouTube: Best Practices to Increase Views

AffiliateXFiles
Ron is dedicated to helping others Learn Affiliate Marketing.

Address:
176a Duroby Creek Rd, Bilambil
NSW 2486
Australia.

Phone: (07) 5590 7739

Copyright © 2008-2017 AffiliateXFiles

Disclaimer: If you buy through any affiliate links on this site Affiliate X Files will earn a commission see our Site Disclaimer or FTC Compliance Notice · Privacy · Social Media Disclosure · TOS · DMCA · Copyright Notice · Sitemap · Advertise · Submit A Guest Post · Anti Spam Policy · External Links Policy · Data Access ·

Powered by Genesis Framework With Child Theme Magazine Pro by StudioPress · Log in

Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}