- Mastering phpMyAdmin 3.4 for Effective MySQL Management
- Marc Delisle
- 462字
- 2021-08-20 15:55:23
Over viewing panels and windows
The phpMyAdmin interface is composed of various panels and windows, each one having a specific function. We will first provide a quick overview of each panel, and then take a detailed look later in this chapter.
Login panels
The login panel that appears depends on the authentication type chosen. For the http
type, it will take the form of our browser's HTTP authentication pop-up screen. For the cookie
type, the phpMyAdmin-specific login panel will be displayed (covered in Chapter 2). For the external authentication (signon
), the login panel is handled by the external application itself. By default, a Server choice dialog and a Language selector are present on this panel.
However, if we are using the config
authentication type, no login panel is displayed, and the first displayed interface contains the navigation and the main panels.
Navigation and main panels
These panels go together and are displayed during most of our working session with phpMyAdmin. The navigation panel is our guide through the databases and tables. The main panel is the working area where the data is managed and results appear. Its exact layout depends on the choices made from the navigation panel and the sequence of operations performed. For the majority of languages (which are written from left to right) the navigation panel is located on the left side and the main panel is on the right, but for right-to-left languages such as Hebrew, these panels are reversed.

The main panel can take the form of the home page. The home page will then contain various links related to MySQL operations or phpMyAdmin information, a Language selector, and possibly the Theme / Style selector.
In the main panel, we can see the Database
view—where we can take various actions about a specific database, or the Table
view—where we can access many functions to manage a table. There is also a Server
view, useful for both system administrator and non-administrator users. All these views have a top menu, which takes the form of tabs that lead to different pages used to present information regrouped by common functions (table structure, privileges, and so on).
Query window
This is a distinct window that is usually opened from the navigation panel—and sometimes from the main panel when editing an SQL query. Its main purpose is to facilitate work on queries and display the results on the main panel.
Starting page
When we start phpMyAdmin, we will see one of the following panels (depending on the authentication type specified in config.inc.php
, and on whether it has more than one server defined in it):
- One of the login panels
- The navigation and main panels with the home page displayed in the main panel
- Oracle從入門到精通(第3版)
- Vue 3移動Web開發與性能調優實戰
- Scala Design Patterns
- JavaScript 網頁編程從入門到精通 (清華社"視頻大講堂"大系·網絡開發視頻大講堂)
- Java編程指南:基礎知識、類庫應用及案例設計
- Spring Cloud、Nginx高并發核心編程
- Java程序設計與實踐教程(第2版)
- 數據結構習題解析與實驗指導
- Extending Puppet(Second Edition)
- C編程技巧:117個問題解決方案示例
- Application Development with Parse using iOS SDK
- Getting Started with React VR
- Oracle 12c從入門到精通(視頻教學超值版)
- 創新工場講AI課:從知識到實踐
- Python程序員面試算法寶典