List:General Discussion« Previous MessageNext Message »
From:Dave Juntgen Date:December 15 2004 4:01pm
Subject:RE: ERROR 1044 (42000): Access denied for user 'root'
View as plain text  
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

Thread
ERROR 1044 (42000): Access denied for user 'root'estoy15 Dec
  • Re: ERROR 1044 (42000): Access denied for user 'root'Gleb Paharenko16 Dec
RE: ERROR 1044 (42000): Access denied for user 'root'Dave Juntgen15 Dec