Hi everyone, as a newbie to linux Im having a but of a problem getting
up and running. Hopefully one of you you can point me in the right
direction. I have installed Centos4 on an old server here at work as a
dev box, installation went well, and I have mysql up and running.
However when I try and connect from my laptop using mysql administrator
I get an error saying “the host is not allowed to connect to this
server” I tried disabling the firewall to see if that helped and it made
no difference. I also tried pinging the server and that was fine.
I tried connecting using the servers ip, name localhost and password as
blank.
When im logged in a root on the server this allows be to login ok.
this is a MySQL question really but...
You need to 'grant' access to the database from the remote client, in
this case you laptop so on the server
grant all on databasename.* to username@host identified by 'password';
flush privileges;
now the databasename and the username are yours to choose and depending
on if the server can resolve the IP that the laptop is on that will
either be its hostname or its IP
thanks
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
