[Cialug] updating mysql users after db relocation

[Matthew Nuzum]

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