What does your '/etc/hosts' file contain? Sounds like it may have the following entry:
127.0.0.1 localhost.localdomain change it to: 127.0.01 localhost or Yes, add 'localhost.localdomain' to mysql.user another option, Why not just SSH to 'daisy' and issue: shell> mysql -u root -p and let it default to localhost. HTH, James > But if I try > > [EMAIL PROTECTED] ~] mysql -h 127.0.0.1 -u root -p > Enter password: > ERROR 1130: Host 'localhost.localdomain' is not > allowed to connect to this > MySQL server > [EMAIL PROTECTED] ~] > > I've googled through a bunch of posts, and the old > line about 'understanding > the words, but not the sentences' applies here. As > best I can tell, this > problem normally comes up when the domain (such as > www.example.com) isn't in > the users table. In this case, 127.0.0.1 should be > equivalent to 'localhost', > which is in there: > > mysql> select host, user, password from mysql.user ; > +------------------+------+------------------+ > | host | user | password | > +------------------+------+------------------+ > | localhost | root | 48bf4fd20c61a2f0 | > | daisy.example.com | root | 48bf4fd20c61a2f0 | > | localhost | | | > | daisy.example.com | | | > +------------------+------+------------------+ > > Do I need to change the 'localhost' entries to > 'localhost.localdomain' in > order for 127.0.0.1 to work? If I do so, will "mysql > -h localhost" then fail? > > I know I could just try it out myself, but I want to > know WHY.... *s* -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
