On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote: > Hi, > The grant stmt has to be as below. > Grant all on databasename.tablename to usern...@iporhostname identified by > 'password'; > > Use as above > Grant stmt doesn't require a flush stmt.
Woops... Seems like the * in my first mail has dissapeared. The correct grant statment I used was: r2-d2# mysql -u root -p grant all on *.* to 'root'@'r2-d2' idenfified by 'secret-password'; grant all on *.* to 'root'@'r2-d2.dahl-stamnes.net' idenfified by 'secret-password'; grant all on *.* to 'root'@'jedi.dahl-stamnes.net' idenfified by 'secret-password'; > ------Original Message------ > From: Jørn Dahl-Stamnes > To: mysql@lists.mysql.com > ReplyTo: sq...@dahl-stamnes.net > Subject: Problem with mysql > Sent: Jan 10, 2010 3:20 PM > > Hello > > I have installed mysql, apache and phpmyadmin on a new server running > Fedora Core 12. > > For some unknown reason I cannot connect to the local host using a full > hostname. > > This is what I have done: > > r2-d2# mysql -u root -p > grant all on . to 'root'@'r2-d2' idenfified by 'secret-password'; > grant all on . to 'root'@'r2-d2.dahl-stamnes.net' idenfified by > 'secret-password'; > > flush privileges; > quit > > r2-d2# mysql -h r2-d2 -u root -p > (works) > > r2-d2# mysql -h r2-d2.dahl-stamnes.net -u root -p > ERROR 1130 (HY000): Host 'r2-d2.dahl-stamnes.net.' is not allowed to > connect to this MySQL server > > > Then I did: > > r2-d2# mysql -u root -p > grant all on . to 'root'@'jedi.dahl-stamnes.net' idenfified by > 'secret-password'; > > jedi# mysql -h r2-d2.dahl-stamnes.net -u root -p > (works) > > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net' > resovl to the same IP-addresse. > > What's wrong? -- 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
