[Cialug] Re: updating mysql users after db relocation

[Matthew Nuzum]

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
>



-- 
Matthew Nuzum
newz2000 on freenode