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 for [EMAIL PROTECTED] | +---------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'mysqladmin'@'localhost' | +---------------------------------------------------------+ 1 row in set (0.00 sec) +++++++++++++++++++++++++++++++++ I would recommend checking the user table in mysql database and see what change your GRANT query did, if any. Let us see what it looks like, if there is any entry for the user you are GRANTing privileges. Regards Aman On Fri, 2004-07-23 at 09:50, Wolfgang Riedel wrote: > 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: There is no such grant defined for user 'mysqladmin' on host > 'localhost' > > What does it mean? What's wrong? > The problem occurs with MySQL-4.0.20 at Linux Fedora, it does not occur > with MySQL-3.23. > > Thanks for any help. > Regards, Wolfgang -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.com Brainbench Certified Linux (RedHat 9) Admin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]