The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?)

Friday

The type or namespace name 'MySql' could not be found:
                                  If you remove or delete the MySql.Data reference from your project library, you will get this type of errors. To resolve this you just follow the below steps.
 Solution:

Step 1: Download the Connector/Net from http://dev.mysql.com/downloads/connector/net/1.0.html

Step 2: Run the downloaded .exe file in to your system.

Step 3: Open your project in Visual Studio --> open references --> delete MySql.Data (old) reference.

Step 4: Right click on references and Add new assembly references for MySql.Data

Step 5: Build your library and you will get Build Succeed.