From: dbadmin
Date: March 16 1999 11:38pm
Subject: Re: Connect Mysql from Win95 to Linux
List-Archive: http://lists.mysql.com/myodbc/40
Message-Id: <36EEEB6B.64E6CD55@on-site.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I have had similar issues and can suggest going to
www.devshed.com. Look at the MySQL tutorial
this will show how to correctly set MySQL permissions
its a combination of  IP(or network name), username and password
MySQL also assigns permissions according to the specific database
within MySQL.The DevShed tuorial explains this quite well.


nosf
Cairns - Australia



Bill Kenihan wrote:

> Yes,I ever tried, but I got same errors.
> I realy don't know how to solve the problem.
>
> Thanks.
> Bill
>
> >From: "Christian Mack" <Mack@stripped>
> >To: 3c4n 3c4n <c3n4@stripped>
> >CC: myodbc <myodbc@stripped>
> >Subject: Re: Connect Mysql from Win95 to Linux
> >Date: Tue, 16 Mar 1999 12:59:37 +0100
> >
> >Hi Bill
> >
> >Did you try to give the IP address of your MySQL host instead of it's
> name in the ODBC-DSN?
> >
> >Tschau
> >Christian
> >
> >3c4n 3c4n wrote:
> >>
> >> Hi
> >> I can ping and I can use telnet work with the linux and MySQL on
> >> linux. but can not use MyODBC.
> >> Now, I found a new case, that is when I restart mysql on linux, then
> >> myodbc get the local IPaddress of the client compuer that running
> >> win95, not the linux computer IPaddress, I don't why? if I try
> >> to connect second,third, ... etc, then myodbc can not get the
> >> IPaddress and always gave the error:
> >>
> >> Key violation
> >> [TCX][MyODBC]Host '' is not allowed to connect to this MySQL server.
> >> Alias: mysql1
> >> BDE Error:9729 [$26][$1]
> >> and
> >> BDE Error:13059 [$33][$3]
> >> Server Error: 1130
> >>
> >> I felt as if that MyODBC can not get the correct host IPaddress in
> >> hosts(under <windows> dir).
> >>
> >> I tried it sevaral days, but I can not make any progress.
> >>
> >> Thanks a lot.
> >>
> >> Bill
> >>
> >> >From: "Christian Mack" <Mack@stripped>
> >> >To: 3c4n 3c4n <c3n4@stripped>
> >> >Subject: Re: Connect Mysql from Win95 to Linux
> >> >Date: Mon, 15 Mar 1999 16:31:56 +0100
> >> >
> >> >3c4n 3c4n wrote:
> >> >>
> >> >> Hi,friend
> >> >> thank you to reply me.
> >> >> I forgot put my name, my name is bill.
> >> >>
> >> >> my config is as bellow:
> >> >> Windows DSN name: mysql1
> >> >> MySQL host(name or IP): Linux
> >> >> MySQL database name: tp
> >> >> User: bill
> >> >> Password:
> >> >> Port(if not 3306): 3307
> >> >>
> >> >> I use delphi2 under windows95, BDE version is 3.0.
> >> >>
> >> >> Thanks.
> >> >>
> >> >> >From: "Christian Mack" <Mack@stripped>
> >> >> >To: c3n4@stripped
> >> >> >CC: myodbc@stripped
> >> >> >Subject: Re: Connect Mysql from Win95 to Linux
> >> >> >Date: Fri, 12 Mar 1999 19:56:09 +0100
> >> >> >
> >> >> >3c4n 3c4n wrote:
> >> >> >>
> >> >> >> I insatlled mysql v3.22.19 on linux, and installed myODBC
> 3.50.22
> >> on
> >> >> >> win95, when I tried to connect to linux mysql, I got the
> following
> >> >> >> problems:
> >> >> >>         Key violation.
> >> >> >>         [TCX][MyODBC]Can't connect to MySQL server on
> Linux(10061)
> >> >> >>         Alias: mysql1
> >> >> >>         BDE Error: 9729         [$26][$1]
> >> >> >> Details:
> >> >> >>         BDE Error: 13059        [$33][$3]
> >> >> >>         Server Error: 2003
> >> >> >>
> >> >< cut >
> >> >
> >> >Hi Bill
> >> >
> >> >Can you connect to the machine called 'Linux' from your Win95
> machine?
> >> >For example does
> >> >C:\> ping Linux
> >> >work from DOS commandline?
> >> >
> >> >If that works, how are the settings in the priviledge tables of the
> >> mysql?
> >> >(It would be good to send at least the 'mysql.user' table entries of
> >> the 'Host', 'User' and 'Password' fields.)
> >> >Perhaps your mysql user 'bill' needs a password, or something like
> >> that.
> >> >
> >> >Tschau
> >> >Christian
> >
>
> Get Your Private, Free Email at http://www.hotmail.com
>
> ---------------------------------------------------------------------
> To request this thread, e-mail myodbc-thread39@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: myodbc-help@stripped