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/
