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