From: Claudio Nanni Date: May 15 2009 8:15pm Subject: Re: Password Reset Not Working List-Archive: http://lists.mysql.com/mysql/217569 Message-Id: <4A0DCD7F.6060207@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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 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) > >