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, Daniel da Veiga <[email protected]> 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.... > One of those times after 7 hours programming were you give such a stupid answer that you decide to stop and go home for a good 12 hours sleep time... Sorry... PS: Tobin is absolutely right. -- 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]