OS X comes with Apache and MySQL as default, but getting them to play together can be a PITA, hence the MAMP suggestion.
Host - I don't know what to write here.
User - I'm guessing this is the user account
yes - probably your administrator account.
Database - database name?
yup, although you can probably leave it blank
Password - database access password?
yup - probably your administrator account password.
Socket - I don't even know what this means.
You can probably leave this blank (3306 is the default port for MySQL to be listening on). If you don't know what a socket is, again, I'll point you in the direction of MAMP, it'll just make your life easier.