Re: Setting up users on mysql - Daniel da Veiga - com.mysql.lists.win32

5 messages in com.mysql.lists.win32Re: Setting up users on mysql

From	Sent On	Attachments
Rick De Rousse	20 Jun 2006 14:07
Daniel da Veiga	20 Jun 2006 14:13
Tobin Cataldo	20 Jun 2006 14:19
Daniel da Veiga	20 Jun 2006 14:22
jbon...@sola.com.au	20 Jun 2006 17:23

Subject:	Re: Setting up users on mysql
From:	Daniel da Veiga (dani...@gmail.com)
Date:	06/20/2006 02:13:02 PM
List:	com.mysql.lists.win32

On 6/20/06, Rick De Rousse <rder...@nhu.edu> wrote:

Hello, I'm having problems setting up users on mysql. I created a database named db1, going to dos prompt and starting mysql > then give it the command: mysql -u=root -p db1; < it then request the password, which I then enter and it comes back with a error #1045 saying " access denied for user '=root@localhost' with password = YES << could you please explain what I'm doing wrong? Thanks

Well, the error is pretty clear, you user@host with pass combination is not allowed to access... How did you create the database? Could you access MySQL before? If all else fail you can try:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

As a last resort....