instable behaviour of mysql

[schlubediwup]

Hi
in the meantime i installed
mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 4.1.9-standard-log |
+--------------------+
1 row in set (0.07 sec)
mysql>
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 
i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>


shows exactly the same behaviour as the older version:

DROP TABLE fili_accounts
DROP TABLE fili_contacts
DROP TABLE fili_knowledge
DROP TABLE fili_tasks
DROP TABLE fili_timer
DELETE FROM participants WHERE ident = 'fili'
DELETE FROM part_val WHERE ident = 'fili'
UPDATE SET activ = 'inactiv' WHERE ident = 'fili'
Query 'UPDATE SET activ = 'inactiv' WHERE ident = 'fili'' failed.
>>>>>MySQL Error Number: 1064: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'SET activ = 'inactiv' WHERE ident = 'fili'' at 
line 1 REVOKE all ON fili_accounts FROM 'fili'@'mydom.tld'
>>>>>MySQL Error Number: 1064: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'SET activ = 'inactiv' WHERE ident = 'fili'' at 
line 1 show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE all ON fili_contacts FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE all ON fili_knowledge FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE all ON fili_tasks FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE all ON fili_timer FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE all ON fili_files FROM 'fili'@'mydom.tld'
Query 'REVOKE all ON fili_files FROM 'fili'@'mydom.tld'' failed.
>>>>>MySQL Error Number: 1147: There is no such grant defined for user 
'fili' on host 'mydom.tld' on table 'fili_files' show grants for 
current_user()
>>>>>MySQL Error Number: 1147: There is no such grant defined for user 
'fili' on host 'mydom.tld' on table 'fili_files' Grants for 
[EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 'root'@'mydom.tld' 
IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT OPTION
REVOKE select ON participants FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE select,update ON part_val FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
REVOKE GRANT OPTION ON *.* FROM 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION
DROP USER 'fili'@'mydom.tld'
show grants for current_user()
Grants for [EMAIL PROTECTED]>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION


and after that
[EMAIL PROTECTED]:~> mysql -h mydom -u root -p
Enter password:
ERROR 1130 (00000): Host 'rosetta.ayni.com' is not allowed to connect to 
this MySQL server
[EMAIL PROTECTED]:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 
i686 i386 GNU/Linux
[EMAIL PROTECTED]:~>

and then doing a
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>

which makes me again go into mysql:
[EMAIL PROTECTED]:~> mysql -h mydom -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.9-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
suomi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]