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>