Re: Setting up users on mysql
Tobin Cataldo <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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.... > -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]