BAUMEISTER Alexandre writes:
> Sinisa,
<xut>
>
> 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.
>
The above error message is expected if you run SELECT ...INTO or
similar on any table in cotations ....
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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