Manage MySQL User Permissions

# Introduction In this project, you will learn how to manage user permissions in a MySQL database. Specifically, you will create a new local user named "Rong" and grant them access to the `performance_schema` database. ## 👀 Preview ```mysql MariaDB [(none)]> SHOW GRANTS FOR Rong@localhost; +-------------------------------------------------------------------------------------------------------------+ | Grants for Rong@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `Rong`@`localhost` IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' | | GRANT SELECT ON `performance_schema`.* TO `Rong`@`localhost` | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.000 sec) ``` ## 🎯 Tasks In this project, you will learn: - How to start the MySQL server and log in to the MySQL terminal - How to create a new local user with a specific password - How to grant a user access to a specific database and its tables ## 🏆 Achievements After completing this project, you will be able to: - Manage user accounts and permissions in a MySQL database - Understand the process of granting and revoking database access for users - Apply these skills to set up user permissions in your own MySQL-based applications

|60 : 00

Click the virtual machine below to start practicing