How to use phpMyAdmin to develop a website (without MySQL experience)

How to use phpMyAdmin to develop a website (without MySQL experience)

Brief description

A web developer who is not well versed into coding websites from scratch can use phpMyAdmin to develop a website even without any prior experience with MySQL.

This article targets IT professionals who have basic knowledge of using Apache, PHP, and MySQL.

Overview

phpMyAdmin (PMA) is a free, open source database client that can be used to interact with MySQL databases quickly. Written in PHP, It offers a graphical interface, and that means you can run commands via your browser without you having to log in to the server. You can easily create and run a website with no prior knowledge of SQL.

In this article, a database called TestWebhosting with one table called Employees shall be created and used to demonstrate how to use phpMyAdmin.

Installation

The Installation of phpMyAdmin on a server is straightforward. For it to run, you should have PHP and MySQL running. Full instructions can be found on their official website.

Access phpMyAdmin from the following address; http://localhost/phpmyadmin. Log in using the root access. Create additional users and grant them access as needed.

Features

PhpMyAdmin has visual interfaces for most tasks, including creating, browsing, and editing tables. Let’s go over the features found on phpMyAdmin.

On the right side of the screen in the database server section, you can see any information about your MySQL server.

In the other two sections on the lower right side, you can also see the version of phpmyadmin you are currently running as well as the MySQL client you have.

Then on the upper left side of the page, you can see the list of databases which the current user has access.

In the databases tab, you can find the list of all available databases which can be managed. Click on any database to control it.

Create a Database

Type the database name; TestWebHosting, Click on Create.

The database is created as shown below;

Create a Table

Type the Table name: Employee and Click Go.

To add values in the table, Type the names of the employees and Click Go.

SQL query

At the top the next tab is SQL. You can run MySQL queries from here.

Export

In the export tab, you use it to export your table. Select the export method, and the Format then click Go.

Import

The import tab is used to import files into your database are saved locally.

Privileges

You can create new accounts, edit permissions from the privileges tab as desired.

Operations

The Operations tab is used to configure phpMyAdmin the way you would like to use it.

Search

From the  Search button, generate a search query for the chosen table.

Structure

By clicking the Structure button, a new page will open that shows the database table’s structure. Choose the operation you would like to execute.

Insert

In the Insert tab, you can add more rows and columns to the tables in MySQL server and click Go.

Drop

To delete a table, use the Drop button, it deletes the whole table and all the records stored in it.

Empty

By using the  Empty button, all data contained in a table is removed without deleting the table.

Conclusion

Besides being more interactive with its visual interface, phpMyAdmin has some nice extras, such as importing and exporting Excel and XML files, and a tool that generates a PDF image of your database schema.

Unlike many standalone MySQL admin tools, phpMyAdmin does not autocomplete code. So unless you are already an expert developer who relies on writing complex SQL queries, phpMyAdmin is an ideal tool.

Check out the top 3 MySQL hosting services:

Kamatera
$4.00 /mo
Starting price
Visit Kamatera
Rating based on expert review
  • User Friendly
    3.5
  • Support
    3.0
  • Features
    3.9
  • Reliability
    4.0
  • Pricing
    4.3
FastComet
$1.79 /mo
Starting price
Visit FastComet
Rating based on expert review
  • User Friendly
    4.7
  • Support
    5.0
  • Features
    4.8
  • Reliability
    4.5
  • Pricing
    5.0
Ultahost
$2.90 /mo
Starting price
Visit Ultahost
Rating based on expert review
  • User Friendly
    4.3
  • Support
    4.8
  • Features
    4.5
  • Reliability
    4.0
  • Pricing
    4.8

How to Install phpMyAdmin on a CentOS 7 VPS or Dedicated Server

Learn how to setup phpMyAdmin on your CentOs 7 VPS server and manage your MySQL/
2 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Install AMPPS on Ubuntu 18.04

AMPPS is a solution stack for Apache, MYSQL, MongoDB, PHP, Perl and Python that
2 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert

How to Enable Full-text Search on MySQL Database

In this guide, we will show you how to enable full-text searches on your MySQL d
2 min read
Idan Cohen
Idan Cohen
Marketing Expert

How to Install PhpMyAdmin on a Ubuntu 18.04 VPS or Dedicated Server

This article will describe the process of installing phpMyAdmin on an Ubuntu 18.
3 min read
Eliran Ouzan
Eliran Ouzan
Web Designer & Hosting Expert
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.
Click to go to the top of the page
Go To Top