Re: Access denied for user 'ODBC'@'localhost'

Yes I tried.

mysql -hlocalhost -uroot -ppassword
Doesn't work.

mysql -hlocalhost -uroot
WORKS! mysql -hlocalhost -ppassword
Doesn't work.

mysql -uroot -ppassword
Doesn't work.

mysql -hlocalhost
Doesn't work.

mysql -uroot
WORKS! mysql -ppassword
Doesn't work.

>From my understanding, it seems like the root password I write is incorrect.
But how can it be possible? It was working perfectly last night, I could connect with the same command and I didn't do any modifications since then. And I'm the only one using this computer.

On 6/28/07, Spencer_McCormack@ganb.uscourts.gov < Spencer_McCormack@ganb.uscourts.gov> wrote:
>
>
> Have you tried it without the localhost option? By default it should
> check localhost first - I believe unless otherwise specified in your
> application.
>
> Spencer McCormack, GANB's Unix/Linux SA
> 404-215-1166
>
> I have PHP&MySQL installed on my system well working.
>
> I get error Access denied for user 'ODBC'@'localhost' when I connect MySQL
> using command line with a command like this :
> mysql -hlocalhost -uroot -ppassword
>
> But I connect with no problem using the following command :
> mysql -uroot
>
> Why do I get error when I specify the host name and password? My final
> purpose is connecting to mysql via PHP. But I get the same error in PHP.
>
>
Received on Thu Jun 28 16:15:35 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek