Access denied for user "ODBC"@"localhost"

------=_Part_53428_28009394.1183053378535
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

------=_Part_53428_28009394.1183053378535--

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

------=_Part_55185_4724672.1183061716596
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.
>
>

------=_Part_55185_4724672.1183061716596--

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

------=_Part_55653_1465584.1183063597853
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I did exactly what is written
here,
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 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
> 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.
> >
> >
>

------=_Part_55653_1465584.1183063597853--

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, 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.
> >
> >


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Access denied for user "ODBC"@"localhost"

The error message you are getting implies that you are trying to connect
as user ODBC not root. Perhaps that is the problem?

John Bonnett=20

-----Original Message-----
From: Ahmed Han [mailto:ahmedhan@gmail.com]=20
Sent: Friday, 29 June 2007 3:26 AM
To: win32@lists.mysql.com
Subject: Access denied for user 'ODBC'@'localhost'

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/win32?unsub=3Dgcdmw-win32@m.gmane.org