List:General Discussion« Previous MessageNext Message »
From:Carlos Proal Date:May 14 2009 10:44pm
Subject:Re: Password Reset Not Working
View as plain text  
Check how many root rows do you have on the user table (select * from 
user where user='root';), some times there are several rows with 
different grants and probably you are going through and invalid rule.

Carlos

On 5/14/2009 5:39 PM, Carlos Williams wrote:
> On Thu, May 14, 2009 at 6:31 PM, Carlos Proal <carlos.proal@stripped> wrote:
>   
>> Hi Carlos
>>
>> Try this
>>
>> mysql>  update user set password=password('letmein') where user='root';
>>
>>
>> This way the password is saved encrypted, thats the way is compared when you
>> try to log in.
>>     
>
> Thanks for the reply! I followed both methods in the following URL / link:
>
>
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
>
> After doing both successfully, I was unable to login over and over. I
> think something is wrong with MySQL. I have never seen this before :(
>
>   

Thread
Password Reset Not WorkingCarlos Williams15 May
  • Re: Password Reset Not WorkingCarlos Proal15 May
    • Re: Password Reset Not WorkingCarlos Williams15 May
      • Re: Password Reset Not WorkingCarlos Proal15 May
        • Re: Password Reset Not WorkingCarlos Williams15 May
          • Re: Password Reset Not WorkingDouglas Nelson15 May
            • Re: Password Reset Not WorkingCarlos Williams15 May
          • Re: Password Reset Not WorkingCarlos Proal15 May
            • Re: Password Reset Not WorkingPJ15 May
            • Re: Password Reset Not WorkingCarlos Williams15 May
              • Re: Password Reset Not WorkingCarlos Williams15 May
                • Re: Password Reset Not WorkingClaudio Nanni15 May
                  • Re: Password Reset Not WorkingCarlos Williams15 May
                    • Re: Password Reset Not WorkingClaudio Nanni15 May