1 / 11

Mysql Admin Gui Utility

Learn how to effectively add a new user in the MySQL Admin GUI utility. This guide details the steps to configure table and column level privileges for users. Discover how to enable the right privileges in the MySQL Admin Utility under the Administrator category. We will walk you through setting up a user named "Jack" with specific select and update privileges on the student table, including inserting values into the students' database. Streamline user management with these important functionalities.

yoshi-walls
Télécharger la présentation

Mysql Admin Gui Utility

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mysql Admin Gui Utility

  2. Add a new User – GUI tool

  3. 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.

  4. 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");

More Related