Over Viewing the Interface - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 57

We can either choose our new password by typing it twice, or use the Generate
button (only available in JavaScript-enabled browsers); in this case, the new
password is shown in a clear field for us to take good note of it, and is automatically
filled into the dialog for changing the password. It is highly recommended to
generate passwords in this way, as they are most likely more secure than a human-
chosen password. To disallow the Change password link from the home page, we
set $cfg['ShowChgPassword'] to FALSE . Privileged users have more options on the
home page. They have more links to manage the server as a whole, for example, the
Privileges link (more on this in Chapter 19 ).
Database view
phpMyAdmin goes into Database view (shown in the following screenshot) every
time we click on a database name from the navigation panel.
This is where we can see an overview of the database—the existing tables, a dialog
to create a table, the tabs to the Database view pages, and some special operations
we might do on this database to generate documentation and statistics. There is
a checkbox beside each table to make global operations on that table (covered in
Chapter 9 ). The table is chosen by using the checkbox or by clicking anywhere on the
row's background. We can also see each table's size, provided $cfg['ShowStats'] is
set to TRUE . This parameter also controls the display of table-specific statistics in the
Table view.
The initial screen that appears here is the database Structure page. We note here that
almost every column header—such as Table , Records , and Size —is a link which can
be used to sort the corresponding column ( Chapter 4 covers sorting). While sorting
by descending table name might not be that useful, sorting by descending size is
definitely something we should do from time to time.
We might want a different initial page to appear while entering the Database
view. This is controlled by the $cfg['DefaultTabDatabase'] parameter, and the
available choices are given in the configuration file as comments.