The MyQl 5.1 DAB exam is series of tasks. The material was
divided into a mandatory section and an optional section. The
mandatory section is a test of core MySQL DBA skills and you must
pass all five. The option section, to be detailed in the next
post, is made up of ten tasks and the candidate must past at
least five of them. This may sound simple but try cramming a full
day of DBA work into two hours and you will have a good idea of
what taking this new exam is like.
The Mandatory Tasks
-
- Account maintenance
-
- Add, delete and modify accounts using the mysql
database.
- Assign privileges for a user on a table and column
basis.
- Reset passwords
- Locate 'anonymous' accounts (where password AND user are both
= '')
Index management