Question 1: If you want to read only the authorized database with the specified user name, how to implement it?
Question 2: There are many members on the website. Now they want to outsource some website functions to third-party companies, but I don’t want to disclose the membership data to them. How do I control the members’ table or the core table to access the specified data, for example, the members’ table can only access testuser1, testuser2, etc.
You can create another mysql account, assign permissions to this account, and specify what tables to look up and write.