How to Set Up a Database for WordPress on My Website
The WordPress program provides a template-driven user interface that allows you to display information to users and gather information from users. It also provides a mechanism to store and retrieve data from a database for the blog. The pages, posts, comments and some configuration parameters are all stored in the database. When you create a new WordPress installation, you need to create a new database, assign permissions to the database and enter that information into a WordPress configuration file.
Other People Are Reading
Instructions
-
Database Setup
-
1
Launch phpMyAdmin or a similar MySQL database tool.
-
2
Click "Privileges" from the list of tasks. Scroll to the bottom of the list of databases displayed and click "Add a New User."
-
-
3
Enter a user name, which will also become the name of the database. Type "%" for the host, enter a password and retype the password. Click the radio button next to "Create Database With the Same Name and Grant All Privileges." Click "Go" at the bottom-right of the screen.
-
4
Click the "Databases" tab to display a list of databases. Scroll to the database you just created and click on it.
-
5
Click the "Operations" tab and change the collation by selecting a different collation from the drop-down list box, for example: "utf8_unicode_ci." Click "Go" after you've selected the new collation.
WordPress Setup
-
6
Open a command-prompt window and change to the directory of the WordPress installation. For example, type:
cd /var/www/myblog
-
7
Create the WordPress configuration file by copying the sample configuration file in the directory. For example, type:
cp wp-config-sample.php wp-config.php
-
8
Edit the WordPress configuration file in an HTML editor or in the Notepad. For example, type:
nano wp-config.php
-
9
Scroll to the section of the file that begins with "** MySQL settings" and locate the three configuration statements for the name of the database, the database username and the database password.
-
10
Replace "database_name_here" with the username/database name you entered when you created the database. Replace "username_here" with the same name. Replace "password_here" with the database password. Keep the single quotes surrounding each name in all three statements. Exit the editor and save the file.
-
11
Open a browser and navigate to the installation utility for the blog installation, for example: www.example.com/myblog/wp-admin/install.php. Verify that the installation program does not issue a database connection error and proceed with the WordPress installation.
-
1
