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.
