Sinisa,
>> mysql> show grants for news@'192.168.1.%';
>>
>+----------------------------------------------------------------------------------------+
>> | Grants for [EMAIL PROTECTED]%
> |
>>
>+----------------------------------------------------------------------------------------+
>> | 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: '[EMAIL PROTECTED]' 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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
