List:MySQL ODBC« Previous MessageNext Message »
From:Patrick Sherrill Date:November 24 1999 9:07pm
Subject:Re: Problem in connecting to MySQL via ODBC on NT
View as plain text  
I think you should RTFM regarding access and permissions.

----- Original Message -----
From: Unix-Contractor, Wipro (CORP) <Wipro.Unix-contractor@stripped>
To: Jeremy Cole <jcole@stripped>; Unix-Contractor, Wipro (CORP)
<Wipro.Unix-contractor@stripped>
Cc: Robert Seward <rseward@stripped>;
<mysql@stripped>
Sent: Wednesday, November 24, 1999 8:03 AM
Subject: RE: Problem in connecting to MySQL via ODBC on NT


> I Got it. If I wont specify the password in ODBC configuration It is
> connecting me to the database,
>
> It is really strange!!!
>
> What do you feel ?
>
> Thanx
>
> mohan
>
> -----Original Message-----
> From: Jeremy Cole [mailto:jcole@stripped]
> Sent: Wednesday, November 24, 1999 8:55 PM
> To: Unix-Contractor, Wipro (CORP)
> Cc: Robert Seward; mysql@stripped
> Subject: Re: Problem in connecting to MySQL via ODBC on NT
>
>
> If you are connecting from another machine, it's only natural that MySQL
> would fail authentication.. make sure in your mysql.user table that you
> have an entry where your user 'mohan' can connect from the host name of
> the NT machine or '%' for all machines.
>
> Btw, "Using Password: YES" does not mean it is using the password "YES",
> it only means that it IS using a password, as opposed to NOT using one.
> The MySQL manual is an excellent reference, you should read it cover to
> cover like I did.. although I've been told it reads like oatmeal.. oh
> well.
>
> Later,
>
> Jeremy
>
> "Unix-Contractor, Wipro (CORP)" wrote:
> >
> > Robert very Good observation I didn't think it is this way,
> > but I have password for this user through which I am trying to connect.
> >
> > This user connects, if I run following command from Unix command prompt
> >
> > indmgt$ mysql -u mohan -pmohan mysql
> >
> > It will connect to database mysql using mohan as username & mohan as
> > password,
> >
> > If I use same username & password from ODBC why MySQL server is not
> > authenticating
> >
> > Thanx
> >
> > mohan
> >
> > -----Original Message-----
> > From: Robert Seward [mailto:rseward@stripped]
> > Sent: Wednesday, November 24, 1999 7:42 PM
> > To: Unix-Contractor, Wipro (CORP)
> > Subject: Re: Problem in connecting to MySQL via ODBC on NT
> >
> > Are you sure the message isn't indicating the presence of a password,
> > not the actual password itself? I think that is what the Unix client
> > does. The Unix client will let you know, if you attempted to connect
> > with a password, but it does NOT display the password. I would check
> > your user table to see if the mysql user requires a password from the
> > host you are connecting from. If it does not require a password and you
> > supply one, the authentication will fail. Strange behaviour but that is
> > how mysql authenticates.
> >
> > Thanks,
> > Rob
> >
> >
> > "Unix-Contractor, Wipro (CORP)" wrote:
> > >
> > > Hi,
> > >
> > >         I have added MySQL server's IP address entry in Win NT hosts
> file,
> > > Now I can ping MySQL server just by specifying server name. But myODBC
> > gives
> > > me same error as follows,
> > >
> > >         "Access denied for user: 'mohan@' [using password:YES]"
> > >
> > >         I don't understand why ODBC is not using correct password
which
> I
> > > configured? Instead it is using YES
> > >
> > > mohan
> > > -----Original Message-----
> > > From: sinisa@stripped [mailto:sinisa@stripped]
> > > Sent: Tuesday, November 23, 1999 10:10 PM
> > > To: Wipro.Unix-contractor@stripped
> > > Cc: mysql@stripped
> > > Subject: RE: Problem in connecting to MySQL via ODBC on NT
> > >
> > > Unix-Contractor, Wipro (CORP) writes:
> > >  > Hi
> > >  >
> > >  > I have specified the IP address directly in ODBC configuration
> > >  >
> > >  > Still should I need to create hosts file on win NT
> > >  >
> > >  > mohan
> > >  >
> > >  > -----Original Message-----
> > >  > From: sinisa@stripped [mailto:sinisa@stripped]
> > >  > Sent: Tuesday, November 23, 1999 9:04 PM
> > >  > To: Wipro.Unix-contractor@stripped
> > >  > Cc: mysql@stripped
> > >  > Subject: RE: Problem in connecting to MySQL via ODBC on NT
> > >  >
> > >  >
> > >  > Unix-Contractor, Wipro (CORP) writes:
> > >  >  >
> > >  >  > Thanx for replying,
> > >  >  >
> > >  >  > I tried your solution, I am hit with following error
> > >  >  >
> > >  >  > "Access denied for user: 'mohan@' [using password:YES]"
> > >  >  >
> > >  >  > What I didn't understand is why the ODBC is using password
> "YES"
(
> > >  >  > eventhough I specify the correct password )
> > >  >  >
> > >  >  > mohan
> > >  >
> > >  >
> > >  > Hi!
> > >  >
> > >  > You have to add the IP address of the machine you are using in
> Windoze
> > >  > hosts table. You can do it via Control Panel/ Networks dialog, or
by
> > >  > manually changing hosts file in etc\ directory.
> > >  >
> > >  > Sinisa
> > >  >
> > >  >
> > +----------------------------------------------------------------------+
> > >  > | TcX  ____  __     _____   _____  ___     ==  mysql@stripped
> > |
> > >  > |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic
> > |
> > >  > |    /*/ /*/ /*/   \*\_   |*|   |*||*|
> > mailto:sinisa@stripped|
> > >  > |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus
> > |
> > >  > |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____
> > |
> > >  > |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> > |
> > >  > |             /*/             \*\                Developers Team
> > |
> > >  >
> > +----------------------------------------------------------------------+
> > >  >
> > >
 > ---------------------------------------------------------------------
> > >  > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> > before
> > >  > posting. To request this thread, e-mail
> > mysql-thread19426@stripped
> > >  >
> > >  > To unsubscribe, send a message to the address shown in the
> > >  > List-Unsubscribe header of this message. If you cannot see it,
> > >  > e-mail mysql-unsubscribe@stripped instead.
> > >  >
> > >
 > ---------------------------------------------------------------------
> > >  > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> > before
> > >  > posting. To request this thread, e-mail
> > mysql-thread19431@stripped
> > >  >
> > >  > To unsubscribe, send a message to the address shown in the
> > >  > List-Unsubscribe header of this message. If you cannot see it,
> > >  > e-mail mysql-unsubscribe@stripped instead.
> > >  >
> > >  >
> > >
> > > Yes, exactly as I told you !!
> > >
> > > Sinisa
> > >
> > >
+----------------------------------------------------------------------+
> > > | TcX  ____  __     _____   _____  ___     ==  mysql@stripped
|
> > > |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic
|
> > > |    /*/ /*/ /*/   \*\_   |*|   |*||*|
mailto:sinisa@stripped|
> > > |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus
|
> > > |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____
|
> > > |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
|
> > > |             /*/             \*\                Developers Team
|
> > >
+----------------------------------------------------------------------+
> > >
> > > ---------------------------------------------------------------------
> > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
> before
> > > posting. To request this thread, e-mail
> mysql-thread19508@stripped
> > >
> > > To unsubscribe, send a message to the address shown in the
> > > List-Unsubscribe header of this message. If you cannot see it,
> > > e-mail mysql-unsubscribe@stripped instead.
> >
> > --
> > Robert Seward       voice: 800 542-9512 x27529
> > Oracle Consultant   pager: 313 684-9843
> > ISP                 fax:   734 741-7641
> >                     email: rseward@stripped
> >                     web:   http://www.noplace.com/rseward/
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
> > posting. To request this thread, e-mail
mysql-thread19516@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail mysql-unsubscribe@stripped instead.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread19519@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
>

Thread
Re: Problem in connecting to MySQL via ODBC on NTPatrick Sherrill25 Nov