Setting up users on mysql

------_=_NextPart_001_01C694AD.86872A41
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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=3Droot -p db1; < it then request the =
password,
which I then enter and it comes back with a error #1045 saying " access
denied for user '=3Droot@localhost' with password =3D YES << could you
please explain what I'm doing wrong?
Thanks


Rick DeRousse
Library Technologist
National Hispanic University
408-273-2734
rderousse@nhu.edu=20



------_=_NextPart_001_01C694AD.86872A41--

Re: Setting up users on mysql

On 6/20/06, Rick De Rousse 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/win32?unsub=gcdmw-win32@m.gmane.org

Re: Setting up users on mysql

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 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/win32?unsub=gcdmw-win32@m.gmane.org

Re: Setting up users on mysql

On 6/20/06, Daniel da Veiga wrote:
> On 6/20/06, Rick De Rousse 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/win32?unsub=gcdmw-win32@m.gmane.org

RE: Setting up users on mysql

mysql -uroot -p db1

no "=3D" is required.

John B.

-----Original Message-----
From: Rick De Rousse [mailto:rderousse@nhu.edu]=20
Sent: Wednesday, 21 June 2006 6:37 AM
To: win32@lists.mysql.com
Subject: Setting up users on mysql

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=3Droot -p db1; < it then request the =
password,
which I then enter and it comes back with a error #1045 saying " access
denied for user '=3Droot@localhost' with password =3D YES << could you
please explain what I'm doing wrong?
Thanks


Rick DeRousse
Library Technologist
National Hispanic University
408-273-2734
rderousse@nhu.edu=20



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org