I know how to create databases and tables using mysql control center and phpmyadmin but I can't find where to add a "user name" and "password". Where am I missing this?
If your host has CPanel installed you will probably have to do it in there. If I remember correctly, its under Advanced Tools => MySQL Databases. There you can add databases, users and then give permissions to the database.
Don't have a Host. Running my own server. Everything is on my local machine. When I set up a new database an "MySQL Control Center" or "PHP Admin" I just can't find the option.
If you're using phpMyAdmin, check whether you are logging in using root account. Check it in 'config.inc.php' file. If it is, then find menu 'Privileges' where you can administer user of the server.