At 7:24 PM -0700 2000-07-23, Daren Cotter wrote:
>trouble is, i did reload it =(
Ah. Bummer. Looking more closely at your query, I see now the
problem is that you said set Password="my_pass" rather than
set Password=PASSWORD("my_pass") -- so your password is who knows
what. You'll need to kill the server and restart with --skip-grant-tables,
then set the password properly and restart without --skip-grant-tables.
>
>Daren Cotter
>Owner, InboxDollars.com
>http://www.inboxdollars.com
>
>----- Original Message -----
>From: Paul DuBois <paul@stripped>
>To: Daren Cotter <easywebmny@stripped>; <mysql@stripped>
>Sent: Sunday, July 23, 2000 4:54 PM
>Subject: Re: NOOOO
>
>
>> At 6:33 PM -0700 2000-07-23, Daren Cotter wrote:
>> >I was attempting to change my root password to mysql and now I cannot get
>in!
>> >
>> >The command I typed was: update user set Password="my_pass" where
>user="root";
>> >
>> >and now "my_pass" will not allow me to connect! I have root access
>> >on the server, can someone please tell me what I need to do???
>>
>> Connect using your old password and issue a FLUSH PRIVILEGES statement.
>> You have changed the grant tables, but not told the server to reread the
>> new table contents. You can also use "mysqladmin reload" from the command
>> line.
>>
>> --
>> Paul DuBois, paul@stripped
>>
>> --
>> ---------------------------------------------------------------------
>> Please check "http://www.mysql.com/php/manual.php" before
>> posting. To request this thread, e-mail mysql-thread45097@stripped
>>
>> To unsubscribe, send a message to:
>> <mysql-unsubscribe-darenc=prairie.lakes.com@stripped>
>>
>> If you have a broken mail client that cannot send a message to the above
>address(Microsoft Outlook), you can use
>http://lists.mysql.com/php/unsubscribe.php
>>
--
Paul DuBois, paul@stripped
