If you have create a user with a database and just want to get on with it you can skip this page and come back here if you ever want to get creative with extra databases and permissions (known as privileges in MySQL).
You might want to create extra databases for users (you might want to have some users with more than one database each. You might also want more than one user to have access to some databases. To create a database log in as root and use this field on the front page of PHPMyAdmin to create a new database:
If it is not there click on the small house icon on the left and look again. You type in a name, choose a collation (UTF-8_general_ci). Click Create and the database is created and opened for you to create tables.
You now need to give permission to some users to use this database. As root go to the Privileges tab and click on the pencil icon next to the user you want to give permission to. Halfway down the page you should see a drop down box which lets you choose a database for the user to have permissions. Pick one and you get a new screen:
On the new page you can give any or all database privileges to the user you selected. Giving all privileges would be normal for small systems. You can also just give privileges to individual tables but for now you do not need to get that precise.
You do not need to create a new database for every new site, page or function. Instead you can put all the tables into one. It's really up to you and how you like to work. If you create a different user for each site and one database for each user that will probably be easiest.
