(OT) Mysql Connection Issue??

[madtoperl]

This node falls below the community's threshold of quality. You may see it by logging in.

[marto]

madtoperl,

This is not a Perl question, this is a MySQL configuration issue. If you google this topic (or rather the error you get) you will find the solution within the first result the search returns. I would suggest that you read the product documentation. Please read the PerlMonks FAQ as you have failed to mark this post as OT (off topic)

Martin

[ciderpunx]

At a guess try :

 mysql -u root -p

Rather than :

 mysql root -u

But have a look in the mysql forums if you get stuck again.

[vek]

The MySQL mailing list has always proven to be good place to ask questions also.

[rodion]

There is a good summary of how to debug "Access Denied" problems at http://dev.mysql.com/doc/refman/5.0/en/access-denied.html. It's a bit long, so you may want to start with careful attention to the item about a third down the page, which talks about how permissions with a "%" wildcards for host can supercede an explicit entry for "localhost". The way this works is counter-intuitive at first, and it is an easy mistake to make.

I appologize in advance to anyone bothered by my answering this off topic question here. I just suspected there are other people like me who are doing primarily Perl, and doing only as much MySQL as they need to. For us, finding the answer to a simple problem with the MySQL documentation can be a little like trying to get a sip of water from a fire hose.