Module 8 Mastery Check

1. What does the following command accomplish?

    GRANT ALL ON monsters.* TO vanhelsing@'%' IDENTIFIED BY "4ber4h4m"; 

2. What command allows the new user giles to log in only from the local host using the password fyarl68 and to look up or look at all databases and tables but nothing else?

3. What command allows you to remove the ALTER , INDEX , DELETE , and DROP privileges from the user [e-mail] on the swords table of the arsenal database?

4. What series of commands removes all of the user privileges of [e-mail] and then deletes the user account and wipes it from the system?

5. What are the possible privileges that can be removed from a user with the REVOKE command?

6. What must you always do before and after using the myisamchk script to avoid further damage to the database?

7. What types of backup files are used with the RESTORE command?

8. What type of backup file does the mysqldump script produce?

9. What command should you use to initially check the tables sandstorms , sandworms , and watercustoms ?

10. What command should you use any time your database has had a great deal of changes made or a large amount of data deleted?