List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 15 2009 8:15pm
Subject:Re: Password Reset Not Working
View as plain text  
Exactly, you need as many rows as many combination  user/host

we can also say that an account in MySQL is not the username BUT the  
username AND host combination.

If you want to duplicate any account (also the root/localhost) do this:

mysql> show grants for 'root'@'localhost';

then have fun!

Claudio



Carlos Williams wrote:
> On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni <claudio.nanni@stripped>
> wrote:
>   
>> I don't know if you are now more ore less confused!
>>
>> Claudio
>>     
>
> I would say less because you basically explained that I need to have
> localhost & 127.0.0.1.
> Now my problem is that no longer have this and would like to know what
> I can do to resolve
> this by re-adding the 127.0.0.1 host / root user parameter back into MySQL.
>
> mysql> use mysql;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
>
> mysql> select user, host, password from user;
> +-----------+------------------------+------------------+
> | user      | host                   | password         |
> +-----------+------------------------+------------------+
> | root           | host.domain.com  | 032c41e8435273a7 |
> | root           | localhost              | 032c41e8435273a7 |
> | roundcube  | localhost              | 032c41e8435273a7 |
> | mrbs          | localhost              | 6322a1af59897de4 |
> | phpbb        | localhost              | 5d2e19393cc5ef67 |
> +-----------+------------------------+------------------+
> 5 rows in set (0.00 sec)
>
>   

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