From: Christian Mack
Date: April 8 1999 8:28pm
Subject: Re: user & password
List-Archive: http://lists.mysql.com/mysql/1544
Message-Id: <370D115A.936ABACA@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

A Dark Elf wrote:
> 
> I added an other user, and even if I give him all rights, and flush the
> privileges, I cant get it to do:
> 
> web:/usr/hd2/home/el$ mysql -e "insert into info values (\"test0\",
> \"1.2.3.4\", \"test2@arpa\", password(\"test2\"), \"1999-04-04
> 13:01:23\");" -pxxxxxx -unobody linuxsupport
> ERROR 1045: Access denied for user: 'nobody@localhost' (Using password:
> YES)
> 
> Patrick Lambert

Hi Patrick

Did you specify the Host as '%' ?
If yes, then you have to drop the anonymous 'localhost' user without password, or add another entry for your user with Host='localhost'.

Hope this helps
Christian