Creating A New Database Using MySql

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:localhostphpmyadmin 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.

1 thought on “Creating A New Database Using MySql

  1. We had never visited the Traverse City area and are so happy that we dcdeeid to do so. We are even more pleased that we dcdeeid to stay at Blackstar Farms Inn. I recently read a statement about another bed & breakfast inn Never before have we stayed in a place so beautiful or so lovingly cared for, nor have we ever felt so pampered. Thank you for making our stay both comfortable and memorable. This statement describes the Inn, the Winery, the Creamery, the Stables, the grounds, and most importantly, the staff at Blackstar Farms. We do plan to return for another beautiful restfull weekend and stay in the suite Mira’ again.Charles & Robyn(Eastpointe, MI)

Leave a Reply

Your email address will not be published. Required fields are marked *