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:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, December 15, 2004 11:34 AM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
