Difference between revisions of "WordPress database"

Revision as of 10:26, 21 April 2016

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

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.

• http://localhost/MAMP/index.php?page=phpmyadmin&language=English

Screenshot:

phpMyAdmin Database tab

On the Default phpMyAdmin page, click the Databass tab:

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

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.

External links

WordPress and phpMyAdmin

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

• Beginner’s Guide to WordPress Database Management with phpMyAdmin
• How to Reset a WordPress Password from phpMyAdmin
• Changing the Site URL