On Monday 11 January 2010 09:55, Ananda Kumar wrote: > use mysql; > select * from user; > > see if you able to see 'r2-d2' entry in this table. > > also you can try this > > grant all on . to 'root'@'%' idenfified by > 'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf. It said that files should be used before dns. After I changed the order, it worked (so did the strange sendmail problem I had). But still I wonder why it worked on the other host, since it also had the order "files dns" in it's nsswitch.conf file... Thanks for your support. -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org