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

I did exactly what is written
here<http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html>, and solved my problem. But I still don't know how this problem occurred out of nowhere in the first place.

On 6/28/07, Ahmed Han <ahmedhan@gmail.com> wrote:
>
> 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:46:57 2007