It's a database server system similar to MS SQL Server, or Oracle. It runs on multiple platforms, Windows, Unix, Linux. It isn't always easy to use or administer. It's used primarily with web hosting and server side scripting (perl, PHP, etc). It can also be used for desktop applications that need a light weight database system.
-tg