List:General Discussion« Previous MessageNext Message »
From:Douglas Nelson Date:May 14 2009 11:01pm
Subject:Re: Password Reset Not Working
View as plain text  
try running the command like this

select * from user where user='root' \G

Capital G is a must.

thanks Doug



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...
>
>   

-- 
<http://sfp.central.sun.com/> 	* Douglas Nelson *
Senior Technical Consultant

*Need Sun JES Help?*
Software Field Practice
Phone +1 877-234-2879/x51438
Mobile 919-259-3719
Email sfp-help@stripped
<http://blogs.sfbay/roller/page/sfp>

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