MySQL is an open source database server, much like Microsoft SQL Server or Oracle.
You can store and retrieve information efficiently, and these are very useful if you run an online store or want to have a bulletin board or other interactive media.
The database stores all the content for the site, and PHP, CGI or ASP scripts retrieve and format this content for the site, making it very easy to update and dynamic.