If you have removed the default anonymous users as recommended by mysql, starting mysqld will report an error (even though mysql started successfully), because the script attempts to issue ''mysqladmin -uxxxx ping'' and the user xxxx no longer exists. I can''t use normal users, because they''re all locked down with passwords, so I''ve inserted a dummy user ''pinger'' and modified the script accordingly to eliminate this error message. The question is, and I''ve found nothing in google, what are the minimum privileges to give a user to enable ''ping'' permissions? I did ''grant usage on *.* to ''pinger''@''localhost'';''. Could I have granted privilege for only one database, for example? -- Collins
On Fri, 2005-03-04 at 07:14 -0700, Collins Richey wrote:> I can''t use normal users, because they''re all locked down with > passwords, so I''ve inserted a dummy user ''pinger'' and modified the > script accordingly to eliminate this error message. The question is, > and I''ve found nothing in google, what are the minimum privileges to > give a user to enable ''ping'' permissions? I did ''grant usage on *.* to > ''pinger''@''localhost'';''. Could I have granted privilege for only one > database, for example?I think the ability to connect to the server is plenty. -- Ignacio Vazquez-Abrams <ivazquez@ivazquez.net> http://centos.ivazquez.net/ -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://lists.caosity.org/pipermail/centos/attachments/20050304/8e89c2a0/attachment.bin
Try : grant usage on ping.* to ''pinger''@''localhost''; On Fri, 04 Mar 2005 10:51:33 -0500, Ignacio Vazquez-Abrams <ivazquez@ivazquez.net> wrote:> On Fri, 2005-03-04 at 07:14 -0700, Collins Richey wrote: > > I can''t use normal users, because they''re all locked down with > > passwords, so I''ve inserted a dummy user ''pinger'' and modified the > > script accordingly to eliminate this error message. The question is, > > and I''ve found nothing in google, what are the minimum privileges to > > give a user to enable ''ping'' permissions? I did ''grant usage on *.* to > > ''pinger''@''localhost'';''. Could I have granted privilege for only one > > database, for example? > > I think the ability to connect to the server is plenty. > > -- > Ignacio Vazquez-Abrams <ivazquez@ivazquez.net> > http://centos.ivazquez.net/ > > > _______________________________________________ > CentOS mailing list > CentOS@caosity.org > http://lists.caosity.org/mailman/listinfo/centos > > > >