In mysql, how to specify that only one or more databases can be accessed for the existing user name, and other database restrictions cannot be accessed or read

  mysql, question

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.