Hi,
SQL Server is a RDBMS and requires WIndows Web server and can be used where you need more security and huge data storage, etc. Where as My SQL basically is a flat file based small rdbms like Visual Foxpro and is platform independent , which is used mostly in Linux based servers and where you dont need too much security and less data.