How to create MySql database using phpMyAdmin

There is a moment in creating web applications and also other types of applications that you need to storage data.

You need to have a place in order to do this. You don’t have choice and preparing your own database instance is must be.

In this tutorial I will present your how to run database using Xampp environment and MySql database server.

Before you start you need to make sure that you have install xampp in your computer. You can use my xampp installation instructions if you don’t know how to start.

Running xampp

Xampp is a mix of well know packages like: MySql server, PHP server, Filezilla server, Merkury etc. For the purpose of this tutorial we will use MySql server.

The question is how to start ? Well we only need to go to apache installation folder. In many cases when you installed apache with default settings you should go to:

C:/xampp

and run xampp-control.exe file. Depending on how your system is configured, running xamppa may require administrative privileges.

Run Apache and MySQL services by click Start buttons.

Creating MySQL database

In xampp environment you have out of the box configured system for mysql management online. It is named phpMyAdmin.

In most case you should be able to run in your web browser the address:

http://localhost/phpmyadmin/

As you can see we have default databases installed in the MySQL server. You should see such databases like:

  • information_schema
  • mysql
  • performance_schema
  • phpmyadmin
  • test

Using phpMyAdmin panel we can build our database and table in two different ways: visually or typing sql commands.

In this tutorial we will select the first option and we create database using specialized sites in phpMyAdmin panel.

Let’s start from creating mysql database.

  1. Click Database link (localized in top menu).
  2. In Database name field type your database name for example my_first_database
  3. In drop down list select utf8-unicode-ci coding for your database.
  4. Click Create button.

When you do everything properly you should have defined your first mysql database named my_first_database.

 

Leave a Reply