I have a remote MySQL server that I am trying to setup through a Data Source. When I at the server and test the connection everything works. It give me the connection string and then you click next. I then save the connection string and click next. It says, Retrieving database information... then comes up with the following error:

An error occured while retrieving information from the database:

SELECT command denied for user 'username' for table 'proc'

Then it will not let me go any further. I have downloaded the GUI tools from MySQL and have been able to successfully connect and navigate the same database from this computer frm the tools.

Any help is greatly appreciated as I am at kind of a stand still with this.

I am currently using VS2008