Solved

Access denied for user 'root' @ 'localhost'

Posted on 2009-05-18
1
388 Views
Last Modified: 2012-05-07
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
Comment
Question by:RobertNZana
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 24413085
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question