Quiz 18

Regarding Reading 18

  1. What database and tables are used to manage MySQL permissions? (list)
  2. Can you run multiple MySQL server instances on one machine? If not, explain why. If so, what configuration options must be different for each instance?
  3. What MySQL command shows you the permissions for a particular user?
  4. What MySQL command can show you the number of "slow queries" run by the server?
  5. What MySQL command can show you the CREATE statement used to create a particular table?
  6. What are the four logs kept by MySQL and what are they for?