I have MySQL 4.0.18-standard on RH 9 and it works fine
+
mysql> grant all on *.* to 'mysqladmin'@'localhost';
Query OK, 0 rows affected (0.06 sec)
mysql> show grants for 'mysqladmin'@'localhost';
+-+
| Grants
I try to set *all* privileges to a user, which should not called 'root'
but should have its privileges (I'm connected as root):
mysql> grant all on *.* to 'mysqladmin'@'localhost';
Query OK, 0 rows affected (0.00 sec)
But now I get
mysql> show grants for 'mysqladmin'@'localhost';
ERROR 1141: Ther
