Regarding Reading 18
- What database and tables are used to manage MySQL permissions? (list)
- 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?
- What MySQL command shows you the permissions for a particular user?
- What MySQL command can show you the number of "slow queries" run by the server?
- What MySQL command can show you the
CREATE statement used to create a particular table?
- What are the four logs kept by MySQL and what are they for?