[Cialug] Re: updating mysql users after db relocation

[Dave J. Hala Jr.]

Did you do a "flush privileges" after you did the update?


:) Dave

On Thu, 2008-02-28 at 09:24 -0600, Matthew Nuzum wrote:
> FTR, this didn't work. I foobar'd my MySQL server. Only root can
> connect, even if I issue additional grant statements for new users.
> 
> On Tue, Feb 26, 2008 at 11:19 AM, Matthew Nuzum <newz at bearfruit.org> wrote:
> > Does anyone know a way to bulk update all of the mysql users so that
> >  they can log in from another host? I've just moved my database from
> >  localhost to a seperate host and I'm trying to figure out how to
> >  update all the users that used to access from localhost so that they
> >  can now access the database remotely.
> >
> >  Can I just update the user table in the mysql database?
> >  use mysql;
> >  update user set host = '192.168.1.103' where user != 'root';
> >
> >  --
> >  Matthew Nuzum
> >  newz2000 on freenode
> >
> 
> 
>