How to create a database for WordPress on my web server?

Question

I want to make a blog for my business and I found a theme fits my need. Can anyone give me some help with install the wordpress? Thank you very much!

There is the "famous 5-minute installation" on wordpress website. Six steps in total, I don't how to do the second one. the second one is "Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and modifying it."

Here is the link page for the six steps:
http://codex.wordpress.org/Installing_WordPress#Famous_5-Minute_Install

It must be easy for people who knows what's MySQL, but I don't know anything about web design or create a database. Can anyone help?

Answer 1

Can you access cPanel on your website?



Email sent to you with information.

Answer 2

First you login to your cPanel, which you can access using this address



yourwebsite.com/cpanel or yourwebsite.com:2082



Then go to "Databases -> MySQL Databases" to create a new database.



Now you'll a user to access it, so slightly under the list of database, you'll see add new user. Create one and then add that user to database.



Now come back to wordpress installation, you already have "Database Name, User Name, Password", leave the Database Host as "localhost" and table prefix as "wp_". Give you blog a name and your email address and you're done.



IMPORTANT: note down the "admin" password after that. You'll need it to login.



If you still in doubt I can install the wordpress for you.

Answer 3

Wp Starter Guide - Wordpress Tutorial!

Answer 4

Your best bet is to contact your web host and find out if they do in fact offer cpanel. If they don't, then you need to find out from them how to install a mysql database on their servers. Most hosts offer a wizard for you in your control panel, whatever it may be, and they have step by step instructions to do so.

Answer 5

1. First login to your cpanel

2. Click on MySQL Databases menu in Databases section

3. Indicate name of the future database and click on Create Database button

4. The database is created and ready to use. Now, in order to be able to fill and maintain the database, MySQL User should be created and assigned to the database with correct privileges. To create MySQL User, find the section called MySQL Users > Add New User and choose username you wish to assign to your database. Once done, choose secure password for MySQL User and type it into corresponding fields.

5. Make sure to save the password, as you will need it to maintain the Database in the Future. After the password is chosen, simply click on Create User button, to finish the process

6. Now you have both MySQL Database and MySQL User created. Now we need to assign MySQL User to the database and set proper privileges. To do this, find Add User To Database section and make sure to choose correct Database and User correspondingly. Once done, simply click on Add button.

7.On the next window you will need to set correct privileges to the MySQL User. In this example, we shall grant all privileges to be able to maintain our MySQL Database without any restrictions, so you simply need to choose All Privileges option and click on Make Changes button

8. Once finished, you will get the message stating that MySQL User was successfully added to the Database

Answer 6

time-kill.com