From the course: CMS Essential Training

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

What is MySQL?

What is MySQL?

Earlier when we discussed the LAMP stack, I mentioned MySQL as an important part of the open-source software stack used to power most open-source content management systems. At the time, I mentioned how MySQL helps us create and manage relational databases. Let's take a closer look at databases and their role in content management systems and then discuss why MySQL is such a popular means of managing those databases. A database is little more than a collection of data and can usually be represented as a table. Relational databases, like those created by MySQL, store data in multiple tables that have the ability to relate to each other in some way, usually by sharing data keys or properties. In the case of content management systems, using relational databases allows them to easily store and organize content in an efficient way while linking that content together. This makes it simple to find all the articles written by a particular author or all articles written about a specific…

Contents