Re: Setting up users on mysql
"Daniel da Veiga" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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.... -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]