Phpmyadmin 简明教程

phpMyAdmin - Databases

启动 Apache 服务器并在 Web 浏览器中打开 /localhost/phpmyadmin phpmyadmin 以打开 phpMyAdmin 界面。

Start the Apache Server and open /localhost/phpmyadmin phpmyadmin in web browser to open the phpMyAdmin interface.

由于我们在 Environment Setup 期间配置了 MySQL 数据库，因此我们的 root 用户的密码为 root@123。phpMyAdmin 打开后，您需要输入相同的凭据才能登录数据库。

As we have configured a database MySQL during Environment Setup, we’ve root user with password as root@123. Once phpMyAdmin opens up, you need to enter same credential to login to database.

login

Dashboard

登录后，您可以在加载的 phpMyAdmin 页面上看到以下部分。左侧部分显示了可用的数据库，它显示了系统用户创建的数据库。

Once logged in, you can see the following sections on the phpMyAdmin page loaded. The left section shows the databases available, it shows system as well user created databases.

schema

在右侧，仪表板显示了一个标签式界面，用于执行所有数据库管理操作，如下图所示。

On the right side, dashboard shows a tabbed interface to do all the database administration operations as shown below.

dashboard

Databases

单击【数据库】选项卡，以查看包含更多详细信息的数据库列表。我们可以在此处创建数据库、迭代数据库和执行其他操作。

Click on Database Tab, to see the list of databases with more details. We can create database, iterate databases and do other operations here.

dashboard databases

单击任何列出的数据库查看包含更多详细信息的表列表。选项卡将根据上下文而改变。现在，选项卡将根据数据库显示。

Click on any listed database to see the list of tables with more details. Tabs changes as per the context. Now tabs will shows as per the database.

dashboard tables

Tables

现在，在模式浏览器中，单击任何表，右侧部分将加载表详细信息，并显示更新的标签式界面以对该表执行各种操作，如下所示：

Now in the schema browser, click on any table, right side section will load the table details as shown with updated tabbed interface to do various operations on that table as shown below −

dashboard table

双击任何单元格，使其可编辑，您可以在其中编辑和保存数据。按 Esc 键不会保存数据。一旦您退出编辑单元格，它将显示更新查询和操作状态，如下所示：

Double clicking on any cell, makes it editable, where you can edit and save data. Pressing esc key, will not save data. Once you move out of editing cell, it will show the update query and status of operation as shown below −

edit data message

您还可以验证更新语句，如下所示：

You can verify the update statement as well as show below −

UPDATE `employees` SET `AGE` = '28' WHERE `employees`.`ID` = 1;

现在，单击【结构】选项卡，它将显示表结构详细信息，如下所示：

Now click on Structure tab, it will show the table structural details as shown below −

table structure