WordPress database

From Wiki @ Karl Jones dot com
Jump to: navigation, search

WordPress uses a MySQL database to store information such as blog posts and page content.

See also WordPress data model.

Using phpMyAdmin

phpMyAdmin is a browser-based tool for working with MySQL databases.

phpMyAdmin and WordPress

To install WordPress, you must first create a database.

You can do this using phpMyAdmin.

phpMyAdmin and MAMP

MAMP is a popular LAMP (software) stack.

Browse the phpMyAdmin link in Localhost. Follow the phpMyAdmin link.

Screenshot:

mamp-page.png

phpMyAdmin Database tab

On the Default phpMyAdmin page, click the Databass tab:

MAMP-phpMyAdmin.png

The Databases view will look something like the screenshot below. Note that I have typed in the word "wordpress" for the database name.

MAMP-phpMyAdmin-create-db.png

Click the Create button. phpMyAdmin will look something like the screenshot below. Note that "wordpress" now appears in the list of databases, in the left column.

You are done in phpMyAdmin. The database is ready for WordPress to use.

In this example I created a database named "wordpress", because that is the the convention.

However, you can name your database something else, so long as you specify the database name in the WordPress installation screen.

MAMP-phpMyAdmin-create-db-complete.png

External links

WordPress and phpMyAdmin

These links relate to phpMyAdmin, a browser-based tool for working with MySQL databases.