MySQL and MS SQL Server are two different DBMS (Database Management Softwares). MS SQL Server is a Microsoft Product. It is much big and costlier than MySQL. MySQL is an open software means it is free to use and even the source are available.
More over MySQL does not support all the features supported by MS SQL Server. You can use MySQL if your requirements are very low and budget is very tight.