Date: Wed, 30 May 2001 01:07:46 -0400 From: Gerard Samuel <trini0@optonline.net> To: Bill Moran <wmoran@iowna.com> Cc: FreeBSD Questions <questions@FreeBSD.ORG> Subject: Re: mysql tcp connection Message-ID: <3B148021.60CB7680@optonline.net> References: <3B144374.996414E9@optonline.net> <3B144ED5.F86EE61B@iowna.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Well I hunted the online doc, and found out how to add a user where they could log on from only my domain. It was a piece of cake after that to connect via tcp. This whole mysql thing is a lot. I jumped in too fast, need to get a book or something.... Bill Moran wrote: > Gerard Samuel wrote: > > > > Hey all. Im trying to use a GUI frontend on windows to control mysql on > > a box on > > my lan. > > Network tcp wise, everything is good. When I try to connect to the box, > > it gets denied access. > > I supplied the correct password, which Ive been using on the console. > > In /usr/local/bin/safe_mysqld, I have > > MYSQL_TCP_PORT=${MYSQL_TCP_PORT:-3306}. > > I tried connecting on that port, but no avail. > > What else needs to be done?? > > Thanks > > Quintinple check your MySQL rights. It's possible to have a user that > can access the server from the localhost, but not from any other host > (the root user is configured this way by default) You can even have > different passwords for the same user from different machines. > MySQL has very complex security. This one feature alone is enough to > confuse anyone. I recommend using a GRANT command to create an entirely > new user with access from any host, if you can then connect as this > user, you know it's the MySQL privies that are causing trouble. > > -Bill > > -- > If a bird in the hand > is worth two in the bush, > then what can I get for > two hands in the bush? 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?3B148021.60CB7680>