List:General Discussion« Previous MessageNext Message »
From:PJ Date:May 14 2009 11:27pm
Subject:Re: Password Reset Not Working
View as plain text  
Carlos Proal wrote:
>
> 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...
>>
>>  
Pardon, for butting in, but are you seriou? unix slut ? My first
impression based on that would be, man you've been hacked! :-D

-- 
Hervé Kempf: "Pour sauver la planète, sortez du capitalisme."
-------------------------------------------------------------
Phil Jourdan --- pj@stripped
   http://www.ptahhotep.com
   http://www.chiccantine.com/andypantry.php

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