Install phpMyAdmin

王林
풀어 주다: 2024-08-29 12:37:23
원래의
447명이 탐색했습니다.

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.

ADVERTISEMENT Popular Course in this category PHP DEVELOPER - Specialization | 8 Course Series | 3 Mock Tests

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

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.

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

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.

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

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

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

Install phpMyAdmin

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

Install phpMyAdmin

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,

Install phpMyAdmin

Install phpMyAdmin

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.

Install phpMyAdmin

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

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).

Install phpMyAdmin

Install phpMyAdmin

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

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.

위 내용은 Install phpMyAdmin의 상세 내용입니다. 자세한 내용은 PHP 중국어 웹사이트의 기타 관련 기사를 참조하세요!

관련 라벨:
php
원천:php
본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿
회사 소개 부인 성명 Sitemap
PHP 중국어 웹사이트:공공복지 온라인 PHP 교육,PHP 학습자의 빠른 성장을 도와주세요!