EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Software Development Software Development Tutorials MariaDB Tutorial MariaDB phpMyAdmin
 

MariaDB phpMyAdmin

Updated April 15, 2023

MariaDB phpMyAdmin

 

 

Introduction to MariaDB phpMyAdmin

MariaDB is the Database Management System used for storing, manipulating, handling, and managing the data which is to be stored in the relational format while phpMyAdmin is the tool used for Web-based applications that helps in the administration of the database management systems such as MySQL and MariaDB. The basic requirement for using the phpMyAdmin tool is to have a web browser, PHP, and a web server installed on your device. This article will cover the overview of using MariaDB DBMS in the PhpMyAdmin tool, a brief overview of both the technologies and the process of configuring and installing PhpMyAdmin, and an example showing the creation of a new database in MariaDB inside the PhpMyAdmin platform.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Mariadb phpmyadmin Overview

PhpMyAdmin is completely written using PHP language and is a software tool available free of cost. This tool can allow us to perform the administrative tasks related to databases of MySQL and MariaDB that involve setting and managing operations such as the permissions, indexes, columns, tables, users, relations, and database visually by using its graphical user interface and at the same time also allow to execute direct query statements in either MySQL or MariaDB. PhpMyAdmin has vast documentation and is open for any changes in the code base and provides support to developers who want to contribute and is completely an open-source application. PhpMyAdmin is flexible and open for changes and at the same time very stable completing a total of 15 years in the market.

How to Install phpMyAdmin?

Before you go for installing PhpMyAdmin, make sure that you have desired database in our case MariaDB should be installed on your machine. The database server which will be connected with PhpMyAdmin should be enabled. The installation of PhpMyAdmin can be carried out by using either of the two ways available. In both ways, there are different prerequisites that need to be followed.

Using Apache Server – MariaDB or MySQL database, PHP and Apache server should be installed before the installation of PhpMyAdmin.

Using WAMP – We can access the PhpMyAdmin tool via the sever available and installed in our machine which makes up the way to administer and manage the database processes.

Installation steps when using Apache Server

  • On your web browser go to this link as shown in the below figure and make use of the first link or simply make a google search of “phpMyAdmin download”. Download the latest version available at your time.

This page contains any other details about the donation for a free application, features and capability and usage of the tool, and also about the previous versions of the tools and their related details which can be seen here –

MariaDB phpMyAdmin output 1

  • The next step is simply clicking on the download symbol and which will result in a zip file getting downloaded that has a name like phpMyAdmin-5.0.2-all-languages with an extension of zipping to it. After running this file, you can see the following output –

MariaDB phpMyAdmin output 2

  • You just need to choose the desired location on your system and then extract the zip file that you downloaded by clicking on the extract all option.

MariaDB phpMyAdmin output 3

  • As the next step open the htdocs folder present inside the C drive containing Apache files and then copy all the contents from the phpMyAdmin extracted folder to htdocs. Further, you can also go for renaming this folder to phpMyAdmin to make it easy for the database to find out the files.

MariaDB phpMyAdmin output 4

  • Search for PHP. ini-production file and rename it to php.ini located in the C drive. Refer to the below figure –

MariaDB phpMyAdmin output 5

MariaDB phpMyAdmin output 5.2

  • Open the above file and change the line containing and remove the semicolon given at the end of the line which allows calling the php functions.

MariaDB phpMyAdmin output 6

  • Now, PhpMyAdmin is completely installed and you can verify the same by typing the http://localhost in the URL section of your browser which will open up the PHPMyAdmin page to you.

Installation phpMyAdmin using WAMP servers –

The steps in the installation are listed below –

  • Go to the link on the browser as shown below –

MariaDB phpMyAdmin output 7

  • You will have to download the WAMPServer application which is available free of cost and its page looks as shown below –

output 8

output 9

  • After, installation. You can see the list of packages and applications that come along with it. We have a functional material package that includes the localhost and Apache applications and also the database MariaDB or MySQL whichever you want to manage and administer. The WAMPServer option can also be set to the taskbar on windows which displays the pink icon.

output 10

Creating databases using phpMyAdmin

The database can be created using PhpMyAdmin by firstly connecting to your database such as MySQL or MariaDB from the http:/localhost url after phpMyAdmin is installed on your device. You can see the below screen –

output 11

Click on create after entering the name of the database and collation to be used as shown below –

output 12

You can check the privileges and user’s information by clicking on the respective tabs –

output 13

Features –

There are many features of PhpMyAdmin MariaDB that are listed below –

  • Data can be imported from SQL or CSV.
  • Data can be exported to a wide range of formats such as ISO/ IEC 26300, SQL, CSV, PDF, XML, and also to spreadsheets and open document text.
  • Provision of global search or even the subset of the database is there.
  • Multiple servers can be administered simultaneously.
  • MySQL and MariaDB features are supported which include drop, create, rename or alter the tables, views, databases, columns, indexes, restrictions, constraints, and fields.
  • The interface provided for the web is very intuitive.
  • We can manage the privileges and accounts of multiple users.
  • The graphical visual format of the database can be created as per requirement which includes many layouts options.
  • Query By Example also referred to as QBE can be used for creating various complex queries.
  • The transformation of stored data to any other predefined data format can be done with the help of predefined functions.
  • Triggers, events, functions, and stored procedures can be managed at a very easy pace.
  • We can make a bookmark or execute the batch queries and SQL queries which further are also allowed to modify.

Conclusion – MariaDB phpMyAdmin

PhpMyAdmin is a tool based on the web where you can administer and manage your database by using easy graphics than that typing in the query statements. Note that phpMyAdmin also allows you to execute the SQL queries.

Recommended Articles

This is a guide to MariaDB phpMyAdmin. Here we discuss the overview of using MariaDB DBMS in the PhpMyAdmin tool, a brief overview of both the technologies. You may also have a look at the following articles to learn more –

  1. MariaDB create table
  2. MariaDB JSON Functions
  3. MariaDB backup
  4. MariaDB boolean

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

🚀 Limited Time Offer! - ENROLL NOW