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

>> >> | 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.%'             |
>> >>
> +----------------------------------------------------------------------------------------+
>>  
>>   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

SM> In which database are tables news, symbole_news ??????

  In database "contenu".

  Alex.

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