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