# Introduction In this project, you will learn how to retrieve the number of users with modify permissions from the user table in a MySQL database. ## ð Preview ![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/mysql/project-number-of-users-with-modify-permissions/lab-number-of-users-with-modify-permissions/assets/img_1.png) ## ðŊ Tasks In this project, you will learn: - How to start and log in to the MySQL terminal - How to switch to the `mysql` database and query the number of users with modify permissions - How to save the SQL statement to a file - How to run the SQL script to display the result ## ð Achievements After completing this project, you will be able to: - Understand how to interact with a MySQL database using the MySQL terminal - Write SQL queries to retrieve specific information from database tables - Save SQL statements to a file and execute them - Apply your MySQL knowledge to solve real-world problems involving user permissions
Click the virtual machine below to start practicing