Access denied for user 'root' @ 'localhost'

Using latest VS2008 and MySql with MyDirect.Net.

I keep getting this error:  "Access denied for user 'root'@'localhost' (using password: YES)"

It happends when I call GetData in the table adapter.  (I'm using an XSD dataset to get the data.)  Any idea how I should fix it?

The GetData returns data fine when I preview it in the DataSet Designer.  I can see the tables in my Server Explorer as well.
LVL 9
RobertNZanaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
first:
do NOT use the ROOT account to connect to a mysql database from your applications.

anyhow, you need to configure the permissions accordingly for (the account).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.