[rt-users] rt2 user right granting, full trying:

[Panizzon Benoit]

Well, I think I have to send some more details:

That's what probably should be sent to MySQL.

DELETE FROM user WHERE user like 'rt_user';
DELETE FROM db where db LIKE 'rt2';
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt2.* TO rt_user at localhost
IDENTIFIED BY 'XXXXXXXX';

And what happens if I ass that manualy:

pflock# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13697 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DELETE FROM user WHERE user like 'rt_user';
Query OK, 0 rows affected (0.02 sec)

mysql> DELETE FROM db where db LIKE 'rt2';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt2.* TO
rt_user at localhost IDENTIFIED BY 'HIDDENXXXX';
ERROR 1044: Access denied for user: 'root at localhost' to database 'rt2'

Anybody an idea what's wrong in this installation?

Benoit Panizzon

------------------------------------------------------------------------
IPH & Partner AG
Birmensdorferstrasse 24
CH - 8902 Urdorf
Tel. +41 (0)1.736.40.50     Fax: +41 (0)1.736.40.51
Mail: bpanizzon at iphpa.ch     www.iphpa.ch
------------------------------------------------------------------------

Die Informationen in dieser E-Mail sind vertraulich und moeglicherweise
rechtlich geschuetzt. Sie sind nur fuer den Adressaten bestimmt. Der
Zugriff durch andere Personen ist nicht erlaubt. Wenn Sie nicht der
beabsichtigte Empfaenger sind, loeschen Sie bitte dieses E-Mail. Jede
Offenlegung dieser E-Mail bzw. der beteiligten Personen, jedes Kopieren,
Versenden oder jede andere Handlung bzw. Unterlassung als Folge dieser
E-Mail ist verboten und kann gegen die Gesetze verstossen.

The information in this e-mail is confidential and may be legally
privileged. It is intended solely for the addressee. Access by another
person ist not authorized. If you are not the intended recipient, please
delete this e-mail. Any disclosure of this e-mail or of the parties to
it, any copying, distribution or any action taken or omitted to be taken
in reliance on it is prohibited, and may be unlawful.
------------------------------------------------------------------------