In WordPress, all information contained in posts, pages, categories and tags are stored in a database, as is information about settings and users. The data is organized in different parts of the database called tables, and each table has different table columns that the table can be sorted by.
For instance, when a visitor views your blog, WordPress asks the database to return information about your latest posts. The posts are stored in a table called
wp_posts, and that table has a column called
post_date. WordPress queries the database for ten rows in the
wp_posts table sorted by the
post_date column, formats those ten posts in the way specified by the active theme, and returns the result to the browser as HTML. Unless a caching solution is used, a database query similar to the one described above occurs every time you visit a page on a WordPress site.
WordPress uses a database management system called MySQL. In order to install WordPress, you need to point the WordPress installation to a MySQL database that WordPress can use to store data.