Could someone here please clarify the difference between a 'DBMS' and 'Database Server' please? And also, is 'MySQL', a name of a database query language or a name of a DBMS?
DBMS stands for Database Management System (see wikipedia http://en.wikipedia.org/wiki/Database) MySQL is a DBMS and it has a server component and a client component, each can run on different or on the same computer.
MySQL, as most DBMS, use SQL as query language (which has been normalized), but also adds some custom queries (see http://dev.mysql.com/doc/refman/5.0/en/extensions-to-ansi.html)