>hi,
>
> i have the following contents in the user table of mysql
>access tables.
>+-----------+------------+------------------+
>| user | host | password |
>+-----------+------------+------------------+
>| root | localhost | 68d4f47c49a579c9 |
>| root | purplestem | |
>| | localhost | |
>| | purplestem | |
>| tms_admin | % | |
>| tms_user | % | |
>+-----------+------------+------------------+
>6 rows in set (0.01 sec)
>
>
>i am able to use 'mysql' program when i am on the localhost (which
>is purplestem). however when i try to connect to the mysql server
>from another machine (snoopy.qualcomm.com) it gives the following
>error.
>
>--------------
>what i do: shell> bin/mysql -hpurplestem -utms_user
>error: ERROR 1130: Host 'snoopy.qualcomm.com' is not allowed to
>connect to this MySQL server
>--------------
>
>the same works fine when i am on purplestem machine.
When you added the tms_admin and tms_user users, did you reload
the grant tables afterward?
--
Paul DuBois, paul@stripped
