How to load the MySQL.Data reference file hosting on the server while it is working fine on the Local Machine

Missing MySQL.Data reference file when hosting on the server  Could not load file or assembly 'MySql.Data, Version=6.2.2.0


This can only be solved only through :;

1. Open the project  in your local machine.
2. Click on the Solution explore.
3. Now click on the References and right click on the  MySQL.Data and see on the properties :--
4. You can now set :  CopyLocal:TRUE;
5. Then copy it to the Hosting Area and you are done.