EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 600+ Courses All in One Bundle
  • Login

Install phpMyAdmin

Home » Software Development » Software Development Tutorials » PHP Tutorial » Install phpMyAdmin

Install phpMyAdmin

Introduction to phpMyAdmin

phpMyAdmin is a Database Administration tool, used for managing the MySQL & MariaDB databases, and it is available in the phpMyAdmin website for cost free as an open source software applications. It was originally written in the PHP scripting language, in order to work around more than one database and related servers. This tool is known for its special features like the provision to import & export multiple formatted files, a web interface, QBE or query by example, global search wizard, database management, and to watch over the current progress for parameters like CPU consumption, database connection range, real time reports, etc.

Pre-requisites

In order to install the phpMyAdmin tool, obviously, one needs to have the desired database installed in their computer. It helps when the database servers are connected and the phpMyAdmin is enabled, in order to perform the database management activities. The prerequisites are the most important part, which needs to be taken care of before actually using the phpMyAdmin tool. Keeping this in check leads to the uninterrupted proper functioning of the utilization of this tool, as the minor glitches can be discouraging and tiresome in the hour of need.

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

There are two ways for installing the phpMyAdmin tool, and both of them need to have the database installed in the computer being installing this tool. Below are the few other prerequisites with respect to the installation processes used.

  • With the Apache Server: In this process, the Apache server, the PHP, and the MySQL database are the softwares that are required to be installed beforehand, that is, before installing the actual phpMyAdmin tool to the same system.
  • With the help of WAMP: When using the WAMP, the phpMyAdmin tool can be accessed via an existing server already installed in the computer, while it allows just the database management & administration processes.

Installation Steps for phpMyAdmin

The Installation process and steps are different for the two different techniques of setting up a phpMyAdmin application on the computer. Below are the steps for working on the same.

1. With the Apache Server

Step 1: Open the web browser and go to the link: https://www.phpmyadmin.net (Fig. 01) from there. Use the direct link, or google as ‘phpMyAdmin download’ and use the first link from the results.

Install phpMyAdmin-1.1

Step 2: The phpMyAdmin application website opens up (Fig. 02), to download the latest version of phpMyAdmin. Please note, the latest version is 5. 0. 2, as of June 2020.

Popular Course in this category
PHP Training (5 Courses, 3 Project)5 Online Courses | 3 Hands-on Project | 28+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.5 (5,694 ratings)
Course Price

View Course

Related Courses
Java Servlet Training (6 Courses, 12 Projects)All in One Software Development Bundle (600+ Courses, 50+ projects)

This web page also contains the other details of the software, such as the detailed description, the databases compatible with the tool, an option for taking a demo of tool usage, an option to voluntarily donate the user’s desired amount for the free application, the extensive list of features that the tool is capable of performing, the hosts/ sponsors for creating this tool and the details of the previous version of the tool.

Install phpMyAdmin-1.2

Step 3: Click on the ‘Download’ button from the above web page (Fig. 03), the browser will prompt a pop up as below and a quick download of the ‘phpMyAdmin-5.0.2-all-languages.zip’ ZIP file will take place.

Install phpMyAdmin-1.3

Step 4: Save the file in the desired location in the computer system (Fig. 04), and extract the contents of the file by right-clicking & selecting the ‘Extract All’ option from the list (Fig. 05).

Install phpMyAdmin-1.4

Install phpMyAdmin-1.5

Step 5: Now, as the next step, locate the ‘htdocs’ folder (Fig. 06) in the Apache files from the local memory, typically it will be in the C: (C drive). Copy the contents of the ‘phpMyAdmin’ folder (Fig. 07) after extraction and paste the same to the Apache ‘htdocs’ folder. And then, rename the destination folder to ‘phpMyAdmin’, so as to allow the database to locate the files with the name as an indicator.

Install phpMyAdmin-1.6

Install phpMyAdmin-1.7

Step 6: Next step is to locate the ‘php.ini-production’ file (Fig. 08) from the PHP folder from the C: (C drive), and rename it into ‘php.ini’ (Fig. 09), as below, in order to make it easy for the phpMyAdmin tool to locate it when it is run,

php-1.8

Install phpMyAdmin-1.9

Step 7: For the next step, open the ‘php.ini’ with Notepad (Fig. 10), and edit the line with extension=php_mbstring.dll to remove the semicolon in that line and save the file, as it prevents phpMyAdmin to call in the PHP functions.

php.in-1.10

Step 8: The phpMyAdmin tool is ready to use now, and if required one can test the same by navigating to ‘http://localhost’ for loading the phpMyAdmin tool’s homepage.

2. With the help of WAMP Servers

Step 1: Open the web browser and go to the link: http://www.wampserver.com/en (Fig. 11) from there. Use the direct link, or google as ‘phpMyAdmin download’ and use the first link from the results.

Install phpMyAdmin-1.11

Step 2: Download the WAMPServer application from there, which is also available for free (Fig. 12). The homepage of WAMPserver also contains details of the software itself, along with the list and features of all the supporting plugins, extensions, public projects, and the aliases such as the phpMyAdmin tool (Fig. 13).

WAMPServer-1.12

WAMPServer-1.13

Step 3: Once the installation is complete, the WAMPServer will display all the items that come along with the package, such as in the below Fig. 14. As you can see, it is seen as a whole package of functional material, which includes the server like the Apache & localhost application, the phpMyAdmin supported databases like MySQL & MariaDB, contains options for importing & exporting almost all the common file types and the Administration tools like phpMyAdmin & Adminer. The WAMPServer logo can also be set under the windows notification box in the taskbar that will be shown as a hot pink W surrounded by a disconnected ring.

Install phpMyAdmin-1.14

Conclusion

The phpMyAdmin tool is normally used on the database applications, as it provides easy and straightforward ways for managing and administering, connected to the common server such as the classic Apache server. This tool was created using the PHP scripting language, and it is used for carrying out Administration activities on the MySQL database.

Recommended Articles

This is a guide to Install phpMyAdmin. Here we also discuss the introduction and pre-requisites along with the installation process and steps. You may also have a look at the following articles to learn more –

  1. Install Magento 2
  2. How to Install Drupal 8?
  3. MySQL Administration
  4. Installing Angular

PHP Training (5 Courses, 3 Project)

5 Online Courses

3 Hands-on Project

28+ Hours

Verifiable Certificate of Completion

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
PHP Tutorial
  • PHP Basic
    • Introduction To PHP
    • What is PHP
    • PHP Keywords
    • Advantages of PHP
    • Career In PHP
    • Comments in PHP
    • PHP Commands
    • PHP Frameworks
    • PHP Compiler
    • Variables in PHP
    • PHP Superglobal Variables
    • PHP Versions
    • Object in PHP
    • What is Drupal
    • Top PHP Frameworks
    • WebStorm IDE
    • What is phpMyAdmin?
    • PhpStorm
    • Install phpMyAdmin
    • Phalcon Model
  • Data Types
    • PHP Data Types
    • PHP Integer
    • PHP Booleans
  • Operators
    • PHP Operators
    • Arithmetic Operators in PHP
    • Comparison Operators in PHP
    • Logical Operators in PHP
    • Bitwise Operators in PHP
    • Ternary Operator in PHP
    • PHP String Operators
  • Control Statements
    • Control Statement in PHP
    • PHP if Statement
    • if else Statement in PHP
    • elseif in PHP
    • PHP Switch Statement
    • Continue in PHP
    • Break in PHP
  • Loops
    • PHP Loops
    • For Loop in PHP
    • PHP Do While Loop
    • PHP While Loop
    • While Loop in PHP
    • Foreach Loop in PHP
  • Constructor
    • Constructor in PHP
    • Destructor in PHP
  • State Management
    • Cookie in PHP
    • Sessions in PHP
  • Array
    • What is PHP Array
    • Arrays in PHP
    • 2D Arrays in PHP
    • Associative Array in PHP 
    • Multidimensional Array in PHP
    • Indexed Array in PHP
    • PHP Array Functions
    • PHP unset Array
    • PHP Append Array
    • PHP Array Search
    • PHP Split Array
    • PHP array_push()
    • PHP array_pop()
  • Functions
    • Functions in PHP
    • PHP Math Functions
    • PHP Recursive Function
    • PHP String Functions
    • Hashing Function in PHP
    • Date Function in PHP
    • PHP Anonymous Function
    • Calendar in PHP
    • PHP Call Function
    • PHP Pass by Reference
    • PHP ucfirst()
    • PHP ucwords()
    • trim() in PHP
    • isset() Function in PHP
    • PHP replace
    • PHP fpm
    • PHP strpos
    • preg_match in PHP
    • PHP preg_replace()
    • PHP ob_start()
    • PHP Reflection
    • PHP Split String
    • PHP URL
    • PHP preg_match_all
    • PHP strtoupper()
    • PHP preg_split()
    • PHP substr_replace()
    • PHP setlocale()
    • PHP substr_count()
    • PHP Serialize
    • PHP strlen()
    • PHP async
    • PHP Date Time Functions
    • PHP timezone
    • PHP Data Object
    • print_r() in PHP
    • PHP header()
    • PHP strip_tags()
    • PHP chop()
    • PHP MD5()
    • PHP unset()
    • PHP crypt()
    • PHP wordwrap()
    • PHP is_null()
    • PHP strtok()
    • PHP bin2hex()
    • PHP parse_str()
    • PHP levenshtein()
    • PHP addslashes()
    • PHP strtotime
    • PHP sha1()
    • PHP explode()
    • PHP sscanf()
    • PHP require_once
    • PHP Zip Files
    • PHP $_SERVER
    • PHP $_POST
    • PHP Include and Require
    • PHP POST Method
  • Advanced
    • Overloading in PHP
    • Overriding in PHP
    • Method Overloading in PHP
    • Inheritance in PHP
    • Multiple Inheritance in PHP
    • PHP Interface
    • Encapsulation in PHP
    • PHP Constants
    • PHP Magic Constants
    • PHP Regular Expressions
    • PHP GET Method
    • PHP Annotations
    • PHP Encryption
    • PHP file Functions
    • PHP readfile
    • PHP?Write File
    • PHP Append File
    • PHP Type Hinting
    • PHP Filters
    • PHP Float
    • PHP Form
    • PHP Form Validation
    • Sorting in PHP
    • PHP usort()
    • PHP Stack Trace
    • PHP Stack Overflow
    • PHP Pagination
    • PHP implode
    • Polymorphism in PHP
    • Abstract Class in PHP
    • PHP Final Class
    • PHP Custom Exception
    • error_reporting() in PHP
    • PHP Log Errors
    • Access Modifiers in PHP
    • PHP Change Date Format
    • Static Method in PHP
    • PHP File Handling
    • PHP Output Buffering
    • Get IP Address in PHP
    • Upload a File in PHP
    • String in PHP
    • Public Function in PHP
    • Private in PHP
    • Protected in PHP
    • basename in PHP
    • Validation in PHP
    • PHP mail()
    • PHP Email Form
    • PHP Directory
    • PHP Create Session
    • PHP include_once
    • PHP json_decode
    • PHP XMLWriter
    • PHP XML Reader
    • PHP XML Parser
    • PHP XML into Array
    • Phalcon Framework
  • Programs
    • Patterns in PHP
    • Star Patterns in PHP
    • Swapping in PHP
    • Fibonacci Series PHP
    • Factorial in PHP
    • Reverse String in PHP
    • Square Root in PHP
    • Random Number Generator in PHP
    • Palindrome in PHP
    • Prime Numbers in PHP
    • Armstrong Number in PHP
    • Socket Programming in PHP
    • Login Page in PHP
    • PHP Login Template
    • PHP Object to String
  • Database
    • PHP Database Connection
    • How to Connect Database to PHP
  • Interview Questions
    • PHP Interview Questions
    • PHP OOP Interview Questions
    • CakePHP Interview Questions
    • Core PHP Interview Questions

Related Courses

PHP Training Course

Java Servlet Training

Software Development Course Training

Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Java Tutorials
  • Python Tutorials
  • All Tutorials
Certification Courses
  • All Courses
  • Software Development Course - All in One Bundle
  • Become a Python Developer
  • Java Course
  • Become a Selenium Automation Tester
  • Become an IoT Developer
  • ASP.NET Course
  • VB.NET Course
  • PHP Course

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

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

*Please provide your correct email id. Login details for this Free course will be emailed to you
Book Your One Instructor : One Learner Free Class

Let’s Get Started

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

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

Forgot Password?

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

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

Special Offer - PHP Training (5 Courses, 3 Project) Learn More