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

Have you tried mysql -h localhost -u root -p
that should work. 

On Thu, 2007-06-28 at 23:15 +0300, Ahmed Han 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, [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.
> >
> >


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]