View Single Post

   
  #3 (permalink)  
Old 04-19-2008, 06:40 PM
Pam Astor
 
Posts: n/a
Default RE: Granting users localhost access


> This should do the trick:
> update mysql.user set host = 'locahost' where user = 'username'
>


Hi Thanks,

OK I tried running:

update mysql.user set host = 'locahost' where user = 'AUserName';
Substituting AUserName for a real username,

got the return:

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

and I tried to login and could not log in remotely via a remote terminal,
which is what I am trying to do.



__________________________________________________ _______________
More immediate than e-mail? Get instant access with Windows Live Messenger.
http://www.windowslive.com/messenger...cc ess_042008
Reply With Quote