Date: Sun, 01 Sep 2002 18:33:30 -0400 From: Bill Moran <wmoran@potentialtech.com> To: Jeff Jeter <gsfgf@softhome.net> Cc: freebsd-questions@freebsd.org Subject: Re: Mysql won't let me in -- Update Message-ID: <3D7295BA.6030203@potentialtech.com> References: <3D70C959.19129.39875B56@localhost> <3D722BFB.27297.3EF08E2D@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
Corey Snow wrote:
> On 1 Sep 2002, at 15:16, Jeff Jeter wrote:
>
>
>>I got it eorking locally, but when i try to connect remotely
>>"mysql -h server" it hangs. How do i allow access. I can't connect
>>w/ ftp, nfs, or telnet to this box either. my /etc/hosts.allow is
>>"ALL : ALL : allow"
Can you please fix your mailer so your lines wrap.
> To be honest, I'm not certain- I haven't tried to access a mysql
> server remotely. However, you'll want to be sure that you can access
> the box by more mundane means (ping, for example) from whatever host
> you're trying to work from. You might just have a connectivity
> problem.
First off, I second the "back to basics" approach. Use ping to make
sure the comptuer is properly configured for IP traffic. If you can't
ping from/to it, fix that before playing with MySQL any more. Once
ping works, install nmap on another computer and scan the MySQL
machine to ensure that it's got the MySQL port open and available.
Mysql security administration is not as simple as it first seems.
Read over the docs on the MySQL site very carefully. The most
important concepts to grasp are:
1. When you log in as "root@localhost" and "root@someotherhost" you
are actually logging in as two different people! Depending on
what entries are in the mysql priveledge database, one or the
other of these accounts may even be denied access!
2. MySQL sorts priviledge entries from most specific to least
specific prior to applying rights. Therefore, the order you
see them listed in the privledge database is not particularly
the order they get applied in.
3. The MySQL mailing lists will do a much better job of answering
your MySQL questions in more detail.
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
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?3D7295BA.6030203>