List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:July 19 2001 1:03pm
Subject:Re[4]: Bug in Mysql access rights ?
View as plain text  
Sinisa,

>> mysql> show grants for news@'192.168.1.%';
>>
> +----------------------------------------------------------------------------------------+
>> | Grants for news@stripped.%                                                    
>        |
>>
> +----------------------------------------------------------------------------------------+
>> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
> 'xxxxxxxxxxxxxxxx'   |
>> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'                            
>        |
>> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%'      
>        |
>> | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%'     
>        |
>>
> +----------------------------------------------------------------------------------------+
>> 
>>   And I have some programs run by cron (once each 5 minutes) which are
>>   connecting from 192.168.1.12.
>> 
>>   Sometimes, my programs are getting the error :
>> 
>> select command denied to user: 'news@stripped' for table 'instrument'
>> 
>>   But  not all the time. At some execution it gets this error, at some
>>   other executions it works fine.
>> 
>>   Table 'instrument' is in database 'cotations'.
>> 
>>   Regards,
>>   Alex.
>> 

SM> The above error message is expected if you run SELECT ...INTO or
SM> similar on any table in cotations ....
 
  But the query is :

SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE n.id=s.news_id
AND i.symbole=s.symbole AND n.id=xxxx LIMIT 1

  Regards,
  Alex.

Thread
Re: Re[2]: Bug in Mysql access rights ?Sinisa Milivojevic19 Jul
  • Re[4]: Bug in Mysql access rights ?BAUMEISTER Alexandre19 Jul