In this tutorial I’m going to show you how to create a new database using MySql and phpMyAdmin for your local test environment websites. You can use the database for WordPress, phpBB, Mediawiki or anything else you may want to experiment with.
Hopefully you will have already read my tutorial on how to install XAMPP so you need to ensure it is running before you start.
Using your favorite web browser type in http:\\localhost\phpmyadmin and hit enter, you should see the screen below:
On this screen click “Privileges” from the top navigation menu.
Click “New User”, see image below:
Give your database a username, select “Local” from the dropdown menu, choose a password and re-type it.
Ensure that “Create database with same name and grant all privileges” is dotted and then click GO, see image below, areas circled in red:
TIP – make sure you write down the username and password for future reference!!
After the confirmation screen click “Privileges” from the top navigation menu and then click the pencil icon next to the new user/database you have just created, see image below:
Click “Check All” and then click “GO”, see image below:
That’s it, you’re now ready to start using your database!! I hope this helps you get started.
Look out for upcoming tutorials on how to install WordPress, install phpBB, install Mediawiki and more.