Date: Tue, 29 Jan 2002 11:15:36 -0500 From: "Ozzie Gurkan" <ozziegurkan@hotmail.com> To: <freebsd-questions@freebsd.org> Subject: Re: Problem with connecting to mysql on another machine Message-ID: <LAW2-OE25dpd75Nl5wA0000d745@hotmail.com> References: <LAW2-OE49bkYw46u76g0000d431@hotmail.com> <LAW2-OE60k2luvGOdDL0000d48f@hotmail.com> <02012821565803.09169@proxy.pt.com> <LAW2-OE50Y2i03LojJo0000d33f@hotmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Well, to resolve my own problem, I decided to install the MySQL server on FreeBSD machine itself. It seems to work now. I still can't understand though why I couldn't get to my XP machine. I was able to get to the XP machine from my other windoze machine, but...It is a mute point now. I have transferred all of my data over to the FreeBSD machine. Ozzie ----- Original Message ----- From: "Ozzie Gurkan" <ozziegurkan@hotmail.com> To: <freebsd-questions@freebsd.org> Sent: Monday, January 28, 2002 10:46 PM Subject: Re: Problem with connecting to mysql on another machine > Actually, I think I have the permissions set correctly because I can get to > the MySQL server from my other windoze machine with an authorization entry > in the users table (on the server) as: root@192.168.1.73. All I did was to > duplicate that entry for authorizing my FreeBSD machine (on the server): > root@192.168.1.99. > > I can connect from my windoze client, but not from my FreeBSD client. I am > still stomped. The mysql-gui (running on FreeBSD client) for X says "Lost > connection to MySQL server during query." It is almost like it isn't finding > it or something. However, I can telnet to the server and it will establish a > connection. > > > On Monday 28 January 2002 22:21, Ozzie Gurkan wrote: > > > > > > I am having problems connecting to mysql server from my FreeBSD > machine. > > > > I have tried using mysqladmin from the command line with no avail. The > process > > > > never returns. I can telnet into port 3306 and the host answers (even > though > > > > it is very difficult to get out of the telnet session). If I connect > from my > > > > windoze machine, I have no problems whatsoever. Is there some network > > > > setting I am missing in my kernel, because I can cvsup, surf the net > and ftp > > > > just fine from the FreeBSD machine? > > > > Are you sure the permissions on the MySQL server are set up to allow you > to log > > in remotely? > > MySQL permissions are a little complicated. You can have multiple > usernames > > from different machines, each with a different set of permissions. If you > haven't > > added any users and issued a "grant" statement on the MySQL server, then > your > > default setup will be (at least this is how it is on a UN*X machine) root > can log > > in locally, and nobody else has any access. > > Read the section of the MySQL manual regarding permissions and the GRANT > > statement and then go over your permissions with a fine-toothed comb, it's > very > > easy to get them wrong. > > Otherwise, check the logs on the MySQL server and see if anything looks > suspicious > > and try using the -v (verbose) option when running mysqladmin. > > > > -- > > Bill Moran > > Potential Technology technical services > > http://www.potentialtech.com > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > > with "unsubscribe freebsd-questions" in the body of the message > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?LAW2-OE25dpd75Nl5wA0000d745>