Database Configuration: MySql with Visual studio 2010

Problem no 1:

There are no mysql option as visul studio 2010 and mysql conflicts each other. This is know issue.

Solution: VS 2010 and connector conflict. Solution Found here

Problem 2:

Database is not allowed to connect.

Possible Solution: Granting Explicit Solution to the indivual user.

Here is the solution

Finally found the solution of Database connection problem. It was because of the

On Windows, root accounts are created that permit connections from the local host only. Connections can be made by specifying the host name localhost, the IP address 127.0.0.1, or the IPv6 address ::1. If the user selects the Enable root access from remote machines option during installation, the Windows installer creates another root account that permits connections from any host.

http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html