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.na...@gmail.com> 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)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
