Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

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.
0
RobertNZana
Asked:
RobertNZana
1 Solution
 
Guy Hengel [angelIII / a3]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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now