List:General Discussion« Previous MessageNext Message »
From:Carlos Proal Date:May 14 2009 11:06pm
Subject:Re: Password Reset Not Working
View as plain text  
The machine  mysql.unixslut.com is not the same than localhost, right ??,
If you only need root access from localhost you can delete the first row 
(delete from user where user='root' and host='mysql.unixslut.com';)


Carlos


On 5/14/2009 5:55 PM, Carlos Williams wrote:
> On Thu, May 14, 2009 at 6:44 PM, Carlos Proal <carlos.proal@stripped> wrote:
>   
>> 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.
>>     
>
> I checked and when I ran the command you suggested:
>
> mysql> use mysql;
> Database changed
>
> mysql> select * from user where user='root';
>
> I get a bunch of gibberish on the screen but the only thing I can make
> out are two entries for root:
>
> | mysql.unixslut.com | root | 6d21bd9609b168e4 | Y           | Y           | Y
> | 127.0.0.1                | root | 6d21bd9609b168e4 | Y           | Y
>           | Y
>
> So what does this mean and how can I resolve this? I am trying this
> from the machine locally so I would assume localhost works fine...
>
>   

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