[Cialug] Re: updating mysql users after db relocation

[Tom Pohl]

Actually, if any of the hosts were localhost or %, you just updated  
them too.  Some mysql clients like PHP tend to use localhost and  
explicitly setting it to your 192.x.x.x ip would make them grumpy :)

-Tom



On Feb 28, 2008, at 9:33 AM, Dave J. Hala Jr. wrote:

> 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
>>>
>>
>>
>>
>
> _______________________________________________
> Cialug mailing list
> Cialug at cialug.org
> http://cialug.org/mailman/listinfo/cialug