1. Connect mysql with root priviledge: $mysql -u root -p
2. Then create database;
3. Grant priviledge to selected users: grant create,drop, select, insert, update, delete on database.table to userABC@localhost;
1. Connect mysql with root priviledge: $mysql -u root -p
2. Then create database;
3. Grant priviledge to selected users: grant create,drop, select, insert, update, delete on database.table to userABC@localhost;