So you created a new database, and now you can't seem to login to phpMyAdmin.

Note: The login to phpMyAdmin is NOT your InstantFreeHosting login details.

Extra Notes: Each MySQL Database you create NEEDS a database user with privileges to access your new database. That's just how it works in MySQL. The phpMyAdmin setup here needs your database user and password details.



Solution:

1. Create your database in the MySQL Setup page. For this example we'll call it mydatabase.

2. Create a database user and give it a password. This option is also on the same page. We'll call it mydatabaseuser, with a password of thisiscool.

3. Assign database privileges for mydatabaseuser to mydatabase. Also found on the same screen.


Now you've got what you need to login to phpMyAdmin.

One more thing to note: If you own say, mycoolname.instantfreehosting.com, and you created the database and user above then:

Your actual phpMyAdmin login name is: mycoolname_mydatabaseuser
Your phpMyAdmin password is: thisiscool

Go try it out!

Unrelated note: You can either assign privileges for the same database user to multiple databases and see all the databases under phpMyAdmin at once, or create a different database user for each different database and only see one database at a time in phpMyAdmin, each with a different login. Up to you.