List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:March 7 2002 9:23am
Subject:Mysql access rights problem ...
View as plain text  
Bonjour,

  I have a problem with Mysql and access rights :

  I  have  a  user  who  has  rights  to access tables in the database
  'membres' :

====================================================================
#/> mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier (Yves.Carlier@stripped)
Changes by Steve Harvey (sgh@stripped)
This software comes with ABSOLUTELY NO WARRANTY.

Access-rights
for USER 'myuser', from HOST '192.168.0.1', to DB 'membres'
        +-----------------+---+ +-----------------+---+
        | Select_priv     | Y | | Shutdown_priv   | N |
        | Insert_priv     | Y | | Process_priv    | N |
        | Update_priv     | Y | | File_priv       | N |
        | Delete_priv     | Y | | Grant_priv      | N |
        | Create_priv     | Y | | References_priv | Y |
        | Drop_priv       | Y | | Index_priv      | Y |
        | Reload_priv     | N | | Alter_priv      | Y |
        +-----------------+---+ +-----------------+---+
NOTE:    A password is required for user `myuser' :-(

The following rules are used:
 db    : '192.168.0.%','membres','myuser','Y','Y','Y','Y','Y','Y','N','Y','Y','Y'
 host  : 'Not processed: host-field is not empty in db-table.'
 user  :
'192.168.0.%','myuser','xxxxxxxxxxxxxxxx','N','N','N','N','N','N','N','N','N','N','N','N','N','N'
 ====================================================================

   This  works fine all day long, but each morning when I come back to
   work, my web site is no more working and the reason is :

ERROR 1044: Access denied for user: 'myuser@stripped' to database 'membres'

   If  I test 'mysqlaccess 192.168.0.1 myuser membres' I have the same
   thing as above.

   And  as soon as I run 'mysqladmin reload' , it corrects the problem
   and my web site is back.

   It's 3 days I have this problem.

   Maybe  a program of mine is doing something that Mysql doesn't like
   each  nights,  but  for  me,  this  shouldn't impact Mysql's access
   rights.

   And  I  don't  understand  why  'mysqlaccess' is returning the good
   result  but  Mysql  isn't  granting  access  before I ask to reload
   access rights ...

   I  had this problem with Mysql-3.23.47, I upgraded to 3.23.49 but I
   still have the same problem.

   Any idea ?

   Regards,
   Alex.

Thread
RH 7.2 connections problems w 16 web servers to 2 MySQL serversSam Iam6 Mar
  • Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversJames Housley6 Mar
  • Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversJeremy Zawodny7 Mar
    • Mysql access rights problem ...BAUMEISTER Alexandre7 Mar
    • Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversSam Iam7 Mar
Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversSteven Roussey6 Mar
RE: RH 7.2 connections problems w 16 web servers to 2 MySQL serversDan Vande More6 Mar
Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversSteven Roussey6 Mar
Re: RH 7.2 connections problems w 16 web servers to 2 MySQL serversMichael Widenius11 Mar
  • Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQL serversPeter Zaitsev11 Mar
    • Re: Re[2]: RH 7.2 connections problems w 16 web servers to 2 MySQLserversSam Iam28 Mar
      • Re[4]: RH 7.2 connections problems w 16 web servers to 2 MySQL serversPeter Zaitsev28 Mar