How do I make a database in MySQL where it needs a name/pass for me to access it?
That depends on what you mean.
if you are trying to create a database and it is asking for a password then you need to know the password and username of an existing database user in order to get to the database in the first place.
If you have access to the database (via root perhaps) then check
http://www.mysql.com/doc/en/User_Account_Management.html
and
http://www.mysql.com/doc/en/CREATE_DATABASE.html#IDX1436