Well as I understand it, it's a database where all user's information is stored. For example if you have a forum and someone registers there, their username, pass, and all other details are stored in that MySQL database...
I can't explain how it works, but to use it just go to phpAdmin and there your database will be shown...