BAUMEISTER Alexandre writes:
> Sinisa,
>
> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
> |
> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO
BAUMEISTER Alexandre writes:
> Sinisa,
>
> >> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
> >> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
> |
> >> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON cont
Sinisa,
>> >> | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD
>'' |
>> >> | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%'
>|
>> >> | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%'
>
Sinisa,
>> mysql> show grants for news@'192.168.1.%';
>>
>++
>> | Grants for [EMAIL PROTECTED]%
> |
>>
>+---
BAUMEISTER Alexandre writes:
> Sinisa,
>
> mysql> show grants for news@'192.168.1.%';
>
>++
> | Grants for [EMAIL PROTECTED]%
>|
>
>+
Sinisa,
>> What's happening ?
SM> Your story is quite strange.
SM> Can you run SHOW GRANTS on both user@localhost and user@remoteIP and
SM> see what they are showing ??
I had to make my applications work, so I removed the lines in 'user'
and 'db' tables for the remote IP. This solved
BAUMEISTER Alexandre writes:
> Bonjour,
>
> What's happening ?
>
> Regards,
> Alex.
Your story is quite strange.
Can you run SHOW GRANTS on both user@localhost and user@remoteIP and
see what they are showing ??
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr
Bonjour,
I have a problem with Mysql-3.23.39 and users access rights. It's
the second time I notice this problem since I installed .39 on two
of my servers. But yesterday, the bug was even more flagrant.
I had a user which had all rights on a database when connecting from
localhos