List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 26 1999 11:26pm
Subject:Re: question about access previleges
View as plain text  
>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
Thread
question about access previlegesSuraj Bhide27 Oct
  • Re: question about access previlegesPaul DuBois27 Oct
    • Re: question about access previlegesSuraj Bhide27 Oct