Date: Mon, 28 Jan 2002 22:46:39 -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-OE50Y2i03LojJo0000d33f@hotmail.com> References: <LAW2-OE49bkYw46u76g0000d431@hotmail.com> <LAW2-OE60k2luvGOdDL0000d48f@hotmail.com> <02012821565803.09169@proxy.pt.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?LAW2-OE50Y2i03LojJo0000d33f>