將 phpMyAdmin 6.0 運作在 docker 上

為什麼要強制升級到 6.0

資料類型支援 vector 向量格式 ( mariadb 11.8 以上)
瀏覽速度和查詢速度一致。5.2.3 之前查詢時間花不到 1 秒，顯示卻常常需要 N 秒以上

docker-compose.yml

  phpmyadmin:
    image: phpmyadmin:5.2.3-apache
    container_name: phpmyadmin
    restart: always
    ports:
      - 8900:80
    environment:
      - PMA_ARBITRARY=1
      - UPLOAD_LIMIT=500M
      - MEMORY_LIMIT=512M
      - MAX_EXECUTION_TIME=3600
    volumes:
      - /docker/db/phpmyadmin6:/var/www/html
      - /docker/db/config.inc6.php:/var/www/html/config.inc.php

phpmyadmin:

image: phpmyadmin:5.2.3-apache

container_name: phpmyadmin

restart: always

ports:

- 8900:80

environment:

- PMA_ARBITRARY=1

- UPLOAD_LIMIT=500M

- MEMORY_LIMIT=512M

- MAX_EXECUTION_TIME=3600

volumes:

- /docker/db/phpmyadmin6:/var/www/html

- /docker/db/config.inc6.php:/var/www/html/config.inc.php

將 5.2.3 更新成 6.0

Downloads · phpMyAdmin

下載 phpMyAdmin-6.0+snapshot-all-languages.zip 解壓縮到 /docker/db/phpmyadmin6

config.inc6.php

從舊版複製修改的，登入時才有伺服器欄位出現

<?php

/* Ensure we got the environment */
$vars = [
    'PMA_ARBITRARY',
    'PMA_HOST',
    'PMA_HOSTS',
    'PMA_VERBOSE',
    'PMA_VERBOSES',
    'PMA_PORT',
    'PMA_PORTS',
    'PMA_SOCKET',
    'PMA_SOCKETS',
    'PMA_USER',
    'PMA_PASSWORD',
    'PMA_ABSOLUTE_URI',
    'PMA_CONTROLHOST',
    'PMA_CONTROLPORT',
    'PMA_PMADB',
    'PMA_CONTROLUSER',
    'PMA_CONTROLPASS',
    'PMA_QUERYHISTORYDB',
    'PMA_QUERYHISTORYMAX',
    'MAX_EXECUTION_TIME',
    'MEMORY_LIMIT',
    'PMA_UPLOADDIR',
    'PMA_SAVEDIR',
];

$cfg['LoginCookieValidity'] = 86400;
$cfg['VersionCheck'] = false;

foreach ($vars as $var) {
    $env = getenv($var);
    if (!isset($_ENV[$var]) && $env !== false) {
        $_ENV[$var] = $env;
    }
}
if (isset($_ENV['PMA_QUERYHISTORYDB'])) {
    $cfg['QueryHistoryDB'] = (bool) $_ENV['PMA_QUERYHISTORYDB'];
}

if (isset($_ENV['PMA_QUERYHISTORYMAX'])) {
    $cfg['QueryHistoryMax'] = (int) $_ENV['PMA_QUERYHISTORYMAX'];
}

/* Arbitrary server connection */
if (isset($_ENV['PMA_ARBITRARY']) && $_ENV['PMA_ARBITRARY'] === '1') {
    $cfg['AllowArbitraryServer'] = true;
}

/* Play nice behind reverse proxys */
if (isset($_ENV['PMA_ABSOLUTE_URI'])) {
    $cfg['PmaAbsoluteUri'] = trim($_ENV['PMA_ABSOLUTE_URI']);
}

/* Figure out hosts */

/* Fallback to default linked */
$hosts = ['db'];

/* Set by environment */
if (! empty($_ENV['PMA_HOST'])) {
    $hosts = [$_ENV['PMA_HOST']];
    $verbose = [$_ENV['PMA_VERBOSE']];
    $ports = [$_ENV['PMA_PORT']];
} elseif (! empty($_ENV['PMA_HOSTS'])) {
    $hosts = array_map('trim', explode(',', $_ENV['PMA_HOSTS']));
    $verbose = array_map('trim', explode(',', $_ENV['PMA_VERBOSES']));
    $ports = array_map('trim', explode(',', $_ENV['PMA_PORTS']));
}

if (! empty($_ENV['PMA_SOCKET'])) {
    $sockets = [$_ENV['PMA_SOCKET']];
} elseif (! empty($_ENV['PMA_SOCKETS'])) {
    $sockets = explode(',', $_ENV['PMA_SOCKETS']);
}

/* Server settings */
for ($i = 1; isset($hosts[$i - 1]); $i++) {
    $cfg['Servers'][$i]['host'] = $hosts[$i - 1];
    if (isset($verbose[$i - 1])) {
        $cfg['Servers'][$i]['verbose'] = $verbose[$i - 1];
    }
    if (isset($ports[$i - 1])) {
        $cfg['Servers'][$i]['port'] = $ports[$i - 1];
    }
    if (isset($_ENV['PMA_USER'])) {
        $cfg['Servers'][$i]['auth_type'] = 'config';
        $cfg['Servers'][$i]['user'] = $_ENV['PMA_USER'];
        $cfg['Servers'][$i]['password'] = isset($_ENV['PMA_PASSWORD']) ? $_ENV['PMA_PASSWORD'] : '';
    } else {
        $cfg['Servers'][$i]['auth_type'] = 'cookie';
    }
    if (isset($_ENV['PMA_PMADB'])) {
      $cfg['Servers'][$i]['pmadb'] = $_ENV['PMA_PMADB'];
      $cfg['Servers'][$i]['relation'] = 'pma__relation';
      $cfg['Servers'][$i]['table_info'] = 'pma__table_info';
      $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
      $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
      $cfg['Servers'][$i]['column_info'] = 'pma__column_info';
      $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
      $cfg['Servers'][$i]['history'] = 'pma__history';
      $cfg['Servers'][$i]['recent'] = 'pma__recent';
      $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
      $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
      $cfg['Servers'][$i]['tracking'] = 'pma__tracking';
      $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
      $cfg['Servers'][$i]['users'] = 'pma__users';
      $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
      $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
      $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
      $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
      $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
      $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
    }
    if (isset($_ENV['PMA_CONTROLHOST'])) {
      $cfg['Servers'][$i]['controlhost'] = $_ENV['PMA_CONTROLHOST'];
    }
    if (isset($_ENV['PMA_CONTROLPORT'])) {
      $cfg['Servers'][$i]['controlport'] = $_ENV['PMA_CONTROLPORT'];
    }
    if (isset($_ENV['PMA_CONTROLUSER'])) {
      $cfg['Servers'][$i]['controluser'] = $_ENV['PMA_CONTROLUSER'];
    }
    if (isset($_ENV['PMA_CONTROLPASS'])) {
      $cfg['Servers'][$i]['controlpass'] = $_ENV['PMA_CONTROLPASS'];
    }
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['AllowNoPassword'] = true;
}
for ($i = 1; isset($sockets[$i - 1]); $i++) {
    $cfg['Servers'][$i]['socket'] = $sockets[$i - 1];
    $cfg['Servers'][$i]['host'] = 'localhost';
}
/*
 * Revert back to last configured server to make
 * it easier in config.user.inc.php
 */
$i--;

/* Uploads setup */
if (isset($_ENV['PMA_UPLOADDIR'])) {
    $cfg['UploadDir'] = $_ENV['PMA_UPLOADDIR'];
}

if (isset($_ENV['PMA_SAVEDIR'])) {
    $cfg['SaveDir'] = $_ENV['PMA_SAVEDIR'];
}

if (isset($_ENV['MAX_EXECUTION_TIME'])) {
    $cfg['ExecTimeLimit'] = $_ENV['MAX_EXECUTION_TIME'];
}

if (isset($_ENV['MEMORY_LIMIT'])) {
    $cfg['MemoryLimit'] = $_ENV['MEMORY_LIMIT'];
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

<?php

/* Ensure we got the environment */

$vars = [

'PMA_ARBITRARY',

'PMA_HOST',

'PMA_HOSTS',

'PMA_VERBOSE',

'PMA_VERBOSES',

'PMA_PORT',

'PMA_PORTS',

'PMA_SOCKET',

'PMA_SOCKETS',

'PMA_USER',

'PMA_PASSWORD',

'PMA_ABSOLUTE_URI',

'PMA_CONTROLHOST',

'PMA_CONTROLPORT',

'PMA_PMADB',

'PMA_CONTROLUSER',

'PMA_CONTROLPASS',

'PMA_QUERYHISTORYDB',

'PMA_QUERYHISTORYMAX',

'MAX_EXECUTION_TIME',

'MEMORY_LIMIT',

'PMA_UPLOADDIR',

'PMA_SAVEDIR',

];

$cfg['LoginCookieValidity'] = 86400;

$cfg['VersionCheck'] = false;

foreach ($vars as $var) {

$env = getenv($var);

if (!isset($_ENV[$var]) && $env !== false) {

$_ENV[$var] = $env;

}

if (isset($_ENV['PMA_QUERYHISTORYDB'])) {

$cfg['QueryHistoryDB'] = (bool) $_ENV['PMA_QUERYHISTORYDB'];

}

if (isset($_ENV['PMA_QUERYHISTORYMAX'])) {

$cfg['QueryHistoryMax'] = (int) $_ENV['PMA_QUERYHISTORYMAX'];

}

/* Arbitrary server connection */

if (isset($_ENV['PMA_ARBITRARY']) && $_ENV['PMA_ARBITRARY'] === '1') {

$cfg['AllowArbitraryServer'] = true;

}

/* Play nice behind reverse proxys */

if (isset($_ENV['PMA_ABSOLUTE_URI'])) {

$cfg['PmaAbsoluteUri'] = trim($_ENV['PMA_ABSOLUTE_URI']);

}

/* Figure out hosts */

/* Fallback to default linked */

$hosts = ['db'];

/* Set by environment */

if (! empty($_ENV['PMA_HOST'])) {

$hosts = [$_ENV['PMA_HOST']];

$verbose = [$_ENV['PMA_VERBOSE']];

$ports = [$_ENV['PMA_PORT']];

} elseif (! empty($_ENV['PMA_HOSTS'])) {

$hosts = array_map('trim', explode(',', $_ENV['PMA_HOSTS']));

$verbose = array_map('trim', explode(',', $_ENV['PMA_VERBOSES']));

$ports = array_map('trim', explode(',', $_ENV['PMA_PORTS']));

}

if (! empty($_ENV['PMA_SOCKET'])) {

$sockets = [$_ENV['PMA_SOCKET']];

} elseif (! empty($_ENV['PMA_SOCKETS'])) {

$sockets = explode(',', $_ENV['PMA_SOCKETS']);

}

/* Server settings */

for ($i = 1; isset($hosts[$i - 1]); $i++) {

$cfg['Servers'][$i]['host'] = $hosts[$i - 1];

if (isset($verbose[$i - 1])) {

$cfg['Servers'][$i]['verbose'] = $verbose[$i - 1];

}

if (isset($ports[$i - 1])) {

$cfg['Servers'][$i]['port'] = $ports[$i - 1];

}

if (isset($_ENV['PMA_USER'])) {

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = $_ENV['PMA_USER'];

$cfg['Servers'][$i]['password'] = isset($_ENV['PMA_PASSWORD']) ? $_ENV['PMA_PASSWORD'] : '';

} else {

$cfg['Servers'][$i]['auth_type'] = 'cookie';

}

if (isset($_ENV['PMA_PMADB'])) {

$cfg['Servers'][$i]['pmadb'] = $_ENV['PMA_PMADB'];

$cfg['Servers'][$i]['relation'] = 'pma__relation';

$cfg['Servers'][$i]['table_info'] = 'pma__table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma__column_info';

$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';

$cfg['Servers'][$i]['history'] = 'pma__history';

$cfg['Servers'][$i]['recent'] = 'pma__recent';

$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';

$cfg['Servers'][$i]['users'] = 'pma__users';

$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';

$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';

$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';

$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';

$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';

$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';

}

if (isset($_ENV['PMA_CONTROLHOST'])) {

$cfg['Servers'][$i]['controlhost'] = $_ENV['PMA_CONTROLHOST'];

}

if (isset($_ENV['PMA_CONTROLPORT'])) {

$cfg['Servers'][$i]['controlport'] = $_ENV['PMA_CONTROLPORT'];

}

if (isset($_ENV['PMA_CONTROLUSER'])) {

$cfg['Servers'][$i]['controluser'] = $_ENV['PMA_CONTROLUSER'];

}

if (isset($_ENV['PMA_CONTROLPASS'])) {

$cfg['Servers'][$i]['controlpass'] = $_ENV['PMA_CONTROLPASS'];

}

$cfg['Servers'][$i]['compress'] = false;

$cfg['Servers'][$i]['AllowNoPassword'] = true;

}

for ($i = 1; isset($sockets[$i - 1]); $i++) {

$cfg['Servers'][$i]['socket'] = $sockets[$i - 1];

$cfg['Servers'][$i]['host'] = 'localhost';

}

* Revert back to last configured server to make

* it easier in config.user.inc.php

$i--;

/* Uploads setup */

if (isset($_ENV['PMA_UPLOADDIR'])) {

$cfg['UploadDir'] = $_ENV['PMA_UPLOADDIR'];

}

if (isset($_ENV['PMA_SAVEDIR'])) {

$cfg['SaveDir'] = $_ENV['PMA_SAVEDIR'];

}

if (isset($_ENV['MAX_EXECUTION_TIME'])) {

$cfg['ExecTimeLimit'] = $_ENV['MAX_EXECUTION_TIME'];

}

if (isset($_ENV['MEMORY_LIMIT'])) {

$cfg['MemoryLimit'] = $_ENV['MEMORY_LIMIT'];

}

1 total views, 1 views today

將 phpMyAdmin 6.0 運作在 docker 上

為什麼要強制升級到 6.0

docker-compose.yml

將 5.2.3 更新成 6.0

config.inc6.php

Related Post

PWA share_target - 使用「分享」突破 Android 網頁上傳照片被移除 Exif GPS 問題

AI 問掛 - Windows 10 修復 .iso 檔案右鍵沒有燒錄光碟錯誤

網頁的前、後端如何區分