mysqld and mysql

[Manuel Arostegui Ramirez]

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

-- 
Manuel Arostegui Ramirez.

Electronic Mail is not secure, may not be read every day, and should not
be used for urgent or sensitive issues.