hi list i have an FC4 machine with mysqld installed with the default configuration, "Say Box A", and i have another FC4 machine which i want to use as a client, say "Box B"
when i start mysqld service on "Box A" and i issue the following command on shell #mysql -u root -p
it simply connects with the server mysqld running on the localhost.
but when i goto "Box B" and issue the following command
#mysql --host="Box A's IP" -u root -p
it says the "Box B" is not allowed to connect to the mysqld server
how to resolve this issue
Regards Azeem
_________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
On Monday 03 September 2007 10:42:14 azeem ahmad wrote:
hi list i have an FC4 machine with mysqld installed with the default configuration, "Say Box A", and i have another FC4 machine which i want to use as a client, say "Box B"
when i start mysqld service on "Box A" and i issue the following command on shell #mysql -u root -p
it simply connects with the server mysqld running on the localhost.
but when i goto "Box B" and issue the following command
#mysql --host="Box A's IP" -u root -p
it says the "Box B" is not allowed to connect to the mysqld server
how to resolve this issue
Probably you may need to give perms to the user, in this scenary, root, with something like:
grant all on *.* to 'root'@'IPBOXA' identified by 'whatever';
Hope this helps Manuel
Somebody in the thread at some point said:
Probably you may need to give perms to the user, in this scenary, root, with something like:
grant all on *.* to 'root'@'IPBOXA' identified by 'whatever';
You're quite right, but also because Azeem didn't paste the actual error message, it can additionally be that he needs to open the server box firewall
# iptables -I INPUT -p tcp --dport 3306 -j ACCEPT # service iptables save
-Andy
-
Andy Green -
azeem ahmad -
Manuel Aróstegui