instable behaviour of mysql

[schlubediwup]

Hi
turns me crazy: no reply button found in your ... mailing-list.
Hello.
Please send us an ouput of the following statement, which you should
perform in the middle of your test case:
 show grants for current_user();
THIS IS THE OUTPUT:
DROP TABLE fai_accounts
DROP TABLE fai_contacts
DROP TABLE fai_knowledge
DROP TABLE fai_tasks
DROP TABLE fai_timer
DELETE FROM participants WHERE ident = 'fai'
DELETE FROM part_val WHERE ident = 'fai'
UPDATE SET activ = 'inactiv' WHERE ident = 'fai'
Query 'UPDATE SET activ = 'inactiv' WHERE ident = 'fai'' 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 = 'fai'' at 
line 1 REVOKE all ON fai_accounts FROM 'fai'@'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 = 'fai'' 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 fai_contacts FROM 'fai'@'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 fai_knowledge FROM 'fai'@'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 fai_tasks FROM 'fai'@'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 fai_timer FROM 'fai'@'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 fai_files FROM 'fai'@'mydom.tld'
Query 'REVOKE all ON fai_files FROM 'fai'@'mydom.tld'' failed.
>>>>>MySQL Error Number: 1147: There is no such grant defined for user 
'fai' on host 'mydom.tld' on table 'fai_files' show grants for 
current_user()
>>>>>MySQL Error Number: 1147: There is no such grant defined for user 
'fai' on host 'mydom.tld' on table 'fai_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 'fai'@'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 'fai'@'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 'fai'@'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 'fai'@'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 i get
[EMAIL PROTECTED]:~> mysql -h mydom.tld -u root -p
Enter password:
ERROR 1130 (00000): Host 'mydom.tld' is not allowed to connect to this 
MySQL server
[EMAIL PROTECTED]:~>


and when i do a (in a valid root window of course)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>
i can login again:
[EMAIL PROTECTED]:~> mysql -h mydom.tld -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 113 to server version: 4.1.7-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]