110 likes | 217 Vues
Mysql Admin Gui Utility. Add a new User – GUI tool. Adding New Users. Enable Table and Column Level Privileges In the MySql Admin Utility Tools – options – Catrgory Administrator – check show global privileges, show schema privileges, show hosts in user list.
E N D
Adding New Users • Enable Table and Column Level Privileges • In the MySql Admin Utility • Tools – options – Catrgory Administrator – check show global privileges, show schema privileges, show hosts in user list.
User privileges using MySql Admin GUI • Set up user “Jack” with only Select and update privileges on the student table • Insert Into students Values (“sarahjessica parker”, "F");