> > 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.>
> > FLUSH PRIVILEGES;
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, etc, and this database is already attached to
a live shopping cart php script which is fully functional.
When you say flush privilages, don't I also need to include the
username for the privilages I am flusing in the command syntax?
_________________________________________________________________
More immediate than e-mail? Get instant access with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008
