Code
Use MySQL;
/* Readonly user & password */
/* Clean user if exists */
Delete from user where user in ('extmail', 'webman ');
Delete from DB where user in ('extmail', 'webman ');
Insert into user (host, user, password) values ('localhost', 'extmail', password ('
Extmail '));
Insert into dB (host, DB, user, select_priv) values ('localhost', 'extmail', 'extm
AIl ', 'y ');
/* Extman read/write user & password */
Insert into user (host, user, password) values ('localhost', 'webman ', password (' W
Ebman '));
Insert into dB (host, DB, user, select_priv, insert_priv, update_priv, delete_pr
Iv) values ('localhost', 'extmail', 'webman ', 'y ');
Flush privileges;
/* Readonly user */
Grant usage on extmail. * To extmail @ localhost;
Grant select, update on extmail. * To extmail @ localhost;
/* Read/write user */
Grant usage on extmail. * To webman @ localhost;
Grant select, insert, delete, update on extmail. * To webman @ localhost;
Create Database extmail;
Use extmail;
/* Table Structure for table manager */
Create Table Manager (.
From an SQL section of extmail, create a user permission Library