> Date: Sat, 19 Apr 2008 20:06:49 +0200
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: mysql@lists.mysql.com
> Subject: Re: Granting users localhost access
>
> Hi Pam,
>
> If you want to grant a specific user remote access i.e. from a shell or
> from an
Hi Pam,
If you want to grant a specific user remote access i.e. from a shell or
from an application that resides on a different machine then you will
have to adjust the query I sent earlier:
update mysql.user set host = '%' where user = 'AUserName';
FLUSH PRIVILEGES;
The above two queries wi
> > I am sorry I do not understand you.> > > > If I Flush privilages, will this
> > flush all privilages for the user?> > If so, I can not do that because
> > these users> > are already used to log into an existing database via a
> > functioning php script and have> > privilages to edit tables,
> > 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 an
> 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)
Ro
Hi there Pam,
This should do the trick:
update mysql.user set host = 'locahost' where user = 'username'
Regards,
Schalk
Pam Astor wrote:
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
__
How do I grant users, who already have a password, localhost
access? I don’t want to change their passwords at this time.
_
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger
