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, [email protected] <
[email protected]> 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.
>
>