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