It sounds like root doesn't have the GRANT permission for the localhost.
You can check by querying the User table in mysql.
David W. Juntgen
Medical Informatics Engineering Inc.
Fax : 260.459.6271
> -----Original Message-----
> From: Guru Vai Kernel-Hacker!!! [mailto:vai@stripped] On
> Sent: Wednesday, December 15, 2004 11:34 AM
> To: mysql@stripped
> Subject: ERROR 1044 (42000): Access denied for user 'root'
> As the root user I created a DB a populated with tables... but when I
> to create a user to handle that DB i get this error message:
> mysql> grant all on db.* to webgui@localhost identified by 'password';
> ERROR 1044 (42000): Access denied for user 'root'
> What could be the reason???
> I though the mysql root user was analogous to the unix counterpart
> Thanks a lot in advance for your help.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: