Ed,
It sounds like root doesn't have the GRANT permission for the localhost.
You can check by querying the User table in mysql.
--Dave
David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax : 260.459.6271
> -----Original Message-----
> From: Guru Vai Kernel-Hacker!!! [mailto:vai@stripped] On
Behalf Of
> estoy@stripped
> Sent: Wednesday, December 15, 2004 11:34 AM
> To: mysql@stripped
> Subject: ERROR 1044 (42000): Access denied for user 'root'
>
> Hi,
>
> As the root user I created a DB a populated with tables... but when I
want
> 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.
>
> Regards,
> Ed
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
