Actually, if you are using the short version -u then you need to omit
the = sign and use -u root instead. If you want to use a long version
then it is --user=root.
Tobin
Daniel da Veiga wrote:
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....
5 messages in com.mysql.lists.win32Re: Setting up users on mysql
