Phpmyadmin 简明教程

phpMyAdmin - Overview

phpMyAdmin 是最受欢迎的免费开源管理工具之一，可用于管理 MySQL 和 MariaDB。它在 GNU GPLv2 下获得许可。它具有基于 Web 的界面，可以在任何平台上轻松使用。它提供 79 种语言版本。它基于 PHP，几乎所有支持 WAMP/LAMP 开发堆栈的网络托管解决方案提供商都提供它。

phpMyAdmin is one the most popular, free and open source administration tool which can manage MySQL and MariaDB. It is licensed under GNU GPLv2. It has a web based interface and can be used on any platform easily. It is available in 79 languages. It is PHP based and is provided by almost all the Web hosting solution providers who supports WAMP/LAMP development stack.

phpMyAdmin 可用于执行有用功能，如使用其基于 Web 的用户界面管理数据库、表格、关系、索引、用户权限等。它还支持查询界面，用户可在其中键入 SQL 命令并运行。

phpMyAdmin can be used to do useful functions like managing databases, tables, relations, indexes, user permissions etc using its web based user interface. It also support a query interface, where user can type SQL commands and run.

phpMyAdmin 有条不紊地记录了文档，并以书籍、博客和文章的形式提供了大量的学习资料。phpMyAdmin 支持 LTR 和 RTL 语言。

phpMyAdmin is neatly documented and lots of learning material is available in form of books, blogs and articles for it. phpMyAdmin supports for LTR and RTL languages.

phpMyAdmin 的开发是社区驱动的，它托管在 GitHub 。它也是 Software Freedom Conservancy 的成员，后者是一个非营利组织，致力于促进、改进、开发和维护免费且开源的项目。

phpMyAdmin development is community driven and is hosted on GitHub. It is also a member of Software Freedom Conservancy which is not-for-profit organization and helps promote, improve, develop and defends free and open source projects.

Prerequisites

以下是使用 phpMyAdmin 所需的重要组件。

Following are the vital components which are required to work with phpMyAdmin.

  1. Web Server − Apache, Nginx, IIS.

  2. PHP − PHP 7.1.3+ is required to work with phpMyAdmin 5.1.1. mysqli and openssl extensions should be enabled.

  3. Database − MySQL 5.5 or MariaDB 5.5 onwards

  4. Web Browser − As phpMyAdmin is a web based application, web browser is required to access it like Google Chrome, Edge, Firefox etc.