MySQL is a database management system, like SQL Server 2005, Oracle, Informix, Postgres etc. MySQL is a RDMS (Relational Database Management System). All types of RDMB use SQL.
MySQL can be used as the back engine database for several kinds of applications and it's one of the best choice for many web programmers for web-base application.