phpmyadmin - default to structure instead of brows

Question

Can I set the default in phpMyAdmin to open in structure instead of browse?

thanks

Answer 1

navigation.php Around Line #646 in phpMyAdmin version 3.3.8 Insert

$href = $GLOBALS['cfg']['LeftDefaultTabTable'] . '?'
            . $GLOBALS['common_url_query']
            .'&table=' . urlencode($table['Name'])
            .'&goto=' . $GLOBALS['cfg']['LeftDefaultTabTable'];

AFTER

$href = $GLOBALS['cfg']['DefaultTabTable'] . '?'
            .$GLOBALS['common_url_query'] . '&table='
            .urlencode($table['Name']) . '&pos=0';

to make the text field name link in the navigation to behave the same as the little icon to the left of it.

Answer 2

In phpMyAdmin 4.8.2...

1. Click the double gears icon at the top of the left navigation pane.
2. Then click the "Tables" tab within the popup modal. (last tab)
3. There you can set the "Target for quick access icon" setting, which is referring to the little index card icon to the left of the table links in the left pane.

I didn't see any settings to change the default link behavior, but you can also add an additional "Target for second quick access icon" and define it's default view behavior differently if desired. It adds an additional "Quick access" icon to the left of the table links with your chosen behavior.

Answer 3

In version 3.5.1: go to the PhpMyAdmin home page -> Settings -> Navigation Frame -> Tables tab. Here you will find an option "Target for quick access icon", and set it

"sql.php" if you want it to go to the Browse tab "tbl_structure.php" if you want it to go to the Structure tab "tbl_sql.php" if you want it to go to the SQL tab "tbl_select.php" if you want it to go to the Search tab "tbl_change.php" if you want it to go to the Insert tab.

Then Save.

This way when you will click on the table name, it will go to the structure; and when clicking on the little icon before the table name, it will go to the tab you just set.

Answer 4

As I said in my comment, you can click on the little table icon to the left of the table name (assuming, as Mike B said, we are talking about the table list on the left) and it will open up the table structure page.

AFAIK, switching the behavior on those links is not possible through a configuration directive. You would have to dig through the code and change it in there. Shouldn't be too complicated, though.

Answer 5

In my version, the configuration setting for it is supposed to be

  $cfg['DefaultTabTable'] = 'tbl_structure.php';

It is listed in sample config file. However, /libraries/navigation/Nodes/Node_Table.class.php on line 34 ignores this setting and uses 'sql.php' directly. I changed that line to

'text' => $GLOBALS['cfg']['DefaultTabTable'].'?server=' . $GLOBALS['server']

On that line and it works fine for me.

Answer 6

I use an old version of XAMPP (1.6.7) which contains an old version of phpMyAdmin (2.11.7), but the following worked for me.

In the /phpmyadmin/libraries/config.default.php file there is a section of code that handles how the table is viewed.

Change the last two lines of code to suit your purposes, for mine I wanted to open tables in "Browse" view, not "Structure" view (which was my default).

   /**
     * Possible values:
     * 'tbl_structure.php' = fields list
     * 'tbl_sql.php' = SQL form
     * 'tbl_select.php' = select page
     * 'tbl_change.php' = insert row page
     * 'sql.php' = browse page
     *
     * @global string $cfg['DefaultTabTable']
     */

    // Show table Structure - Default
    $cfg['DefaultTabTable'] = 'tbl_structure.php';

    // Uncomment below to show table data
    // $cfg['DefaultTabTable'] = 'sql.php';

Save this config file and refresh PhpMyAdmin in your browser.

Hope that helps!