List:General Discussion« Previous MessageNext Message »
From:sureshkumarilu Date:January 10 2010 11:34am
Subject:Re: Problem with mysql
View as plain text  
Hi,
The grant stmt has to be as below. 
Grant all on databasename.tablename to username@IPorHostname  identified by 'password';

Use as above
Grant stmt doesn't require a flush stmt.

Suresh Kuna
MySQL DBA

------Original Message------
From: Jørn Dahl-Stamnes
To: mysql@lists.mysql.com
ReplyTo: sql06@stripped
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=1lu@stripped



Sent from BlackBerry® on Airtel
Thread
Problem with mysqlJørn Dahl-Stamnes10 Jan
  • Re: Problem with mysqlMihamina Rakotomandimby11 Jan
    • Re: Problem with mysqlJørn Dahl-Stamnes11 Jan
      • Re: Problem with mysqlAnanda Kumar11 Jan
        • Re: Problem with mysqlJørn Dahl-Stamnes11 Jan
      • Re: Problem with mysqlMihamina Rakotomandimby11 Jan
      • Re: Problem with mysqlMihamina Rakotomandimby11 Jan
        • Re: Problem with mysqlJørn Dahl-Stamnes11 Jan
Re: Problem with mysqlsureshkumarilu10 Jan
Re: Problem with mysqlJørn Dahl-Stamnes10 Jan