HostOnNet Blog

How to create MYSQL database using PhpMyAdmin in localhost

I was planning to develop a tourism website on WordPress. As a first step, I installed LAMP on my PC in which I am using Ubuntu 16.04.

Then I installed PhpMyAdmin on my computer by following this tutorial.

Then started procedure to install WordPress in localhost. Before that I created MySQL database by following below steps:

First of all you need to have LAMP or WAMP installed in your Computer. As you read from above, I already installed the same. Then following below steps:

First of all launch local web server, ie, LAMP

I opened the browser, navigated to http://localhost/phpmyadmin

Then click on Databases tab.

In the next page, we will see option to Create a Database and input field for entering Database name. I filled database name. After that clicked on Create button

After a few seconds a popup success message will be displayed.

Now you can see your database from the list of tables on left hand side of the page.

You can use this database in any of the project and hostname is “localhost“, by default MySQL user is “root” and no password.


About ramesh xavier

Hi I am Ramesh Xavier I have a passion for designing detailed, creative and modern websites, I have been working as web-designer for over 4 years, and have done lots of work over that time, I'm always keeping an eye on the latest trends over typography, shapes, colours, etc..