[debian-mysql] Bug#437870: closed by Christian Hammers <ch at debian.org> (Re: Bug#437870: mysql-server-5.0: Host '10.1.1.105' is not allowed to connect to this MySQL)

[Lukasz Szybalski]

On 8/20/07, Debian Bug Tracking System <owner at bugs.debian.org> wrote:
> This is an automatic notification regarding your Bug report
> #437870: mysql-server-5.0: Host '10.1.1.105' is not allowed to connect to this MySQL,
> which was filed against the mysql-server-5.0 package.
>
> It has been closed by Christian Hammers <ch at debian.org>.
>
> Their explanation is attached below.  If this explanation is
> unsatisfactory and you have not received a better one in a separate
> message then please contact Christian Hammers <ch at debian.org> by replying
> to this email.
>
> Debian bug tracking system administrator
> (administrator, Debian Bugs database)
>
>
>
> ---------- Forwarded message ----------
> From: Christian Hammers <ch at debian.org>
> To: Lukasz Szybalski <szybalski at gmail.com>, 437870-done at bugs.debian.org
> Date: Mon, 20 Aug 2007 22:19:20 +0200
> Subject: Re: [debian-mysql] Bug#437870: mysql-server-5.0: Host '10.1.1.105' is not allowed to connect to this MySQL
> Hello Lokasz
>
> On 2007-08-14 Lukasz Szybalski wrote:
> > Hello,
> > I finally figured that root access is disabled as a default. (I
> > believe it wasn't the case in previous version, but not sure.)
> >
> > A user need to create a different user that he will be used to access
> > mysql from outside.
> >
> > section of /usr/share/doc/mysql-server-5.0/README.Debian.gz should
> > include this sentence.
> >
> > * Networking
> > .....................................
> > Root access is disabled from any address except for 127.0.0.1. User
> > should create a different user to log in from outside of 127.0.0.1 or
> > enable root user to login from @.
>
> Well our README.Debian is already pretty long and I hesitate to add
> more notes to it because I fear that people won't read it else.

I always would assume that we should be explicit (make it obvious)
then implicit (make people guess) but it is up to you.

I agree that long documentation might be a dulling but missing
information seems worse to me.

I'll leave that call to you. Thanks, for maintaining this package and
a fast response.

Lucas

ps. for google purposes.
"Debian etch mysql-server package allows localhost connection only for
root account."


>
> Especially when in this case it is working as described in the manual. MySQL
> has access lists with host, user, password fields etc so if it says
> "rejected" it's likely that they miss root at anywhere.
>
> BTW, if you're new to MySQL have a look at the "mysqlaccess" tool.
> It's handy to find out which rights a user will have.
>
> bye,
>
> -christian-
>
>
>


-- 
-- 
Linux is not magic. It just works.
http://www.lucasmanual.com