Daily Archives: August 6, 2008

How to create user and give the necessary grants:

create user 'ms'@'111.222.11.22' identified by 'swkb123';

grant select, delete, insert, update on myschema.* to 'ms'@'111.222.11.22'
grant all privileges on myschema.* to 'ms'@'111.222.11.22';
  (more…)