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>

cellino@mydom:~> uname -a
Linux rosetta 2.6.4-54.5-default #1 Fri May 7 21:43:10 UTC 2004 i686 
i686 i386 GNU/Linux
cellino@mydom:~>



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 root@stripped=>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 root@stripped=>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 root@stripped=>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 root@stripped=>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 root@stripped=>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 
root@stripped=>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 root@stripped=>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 root@stripped=>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 root@stripped=>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 root@stripped=>GRANT ALL PRIVILEGES ON *.* TO 
'root'@'mydom.tld' IDENTIFIED BY PASSWORD '17e741d62b857bab' WITH GRANT 
OPTION




and after that

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


and then doing a


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>




which makes me again go into mysql:


cellino@mydom:~> 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