Code USE mysql; /* readonly user & password */ /* clean user if exists */ deleteFROMuserwhereUserin ('extmail','webman'); deleteFROM db whereUserin ('extmail','webman');
/* readonly user */ GRANT USAGE ON extmail.*TO extmail@localhost; GRANTSELECT, UPDATEON extmail.*TO extmail@localhost;
/* read/write user */ GRANT USAGE ON extmail.*TO webman@localhost; GRANTSELECT, INSERT, DELETE, UPDATEON extmail.*TO webman@localhost; CREATEDATABASE extmail; USE extmail;
/* Table structure for table manager */ CREATETABLE manager (.