List:General Discussion« Previous MessageNext Message »
From:Jørn Dahl-Stamnes Date:January 10 2010 1:17pm
Subject:Re: Problem with mysql
View as plain text  
On Sunday 10 January 2010 12:34, sureshkumarilu@stripped wrote:
> 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.

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@stripped
> 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/
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