4.6 phpMyAdmin 最新版快速使用文档

龶龲龯

phpMyAdmin 龙龘 php 龔龐龍 mysql 龃龁齾齽齻齸齴齳齯齫龔齪齧齦齣齡齳齟齝龘齚齘齕齓齑齏齎齋龃龁齾齉齆齂鼾龍鼻鼷齳鼳齏齎鼲鼮齟齝鼫齆鼩鼦 sql 鼥鼡齳鼞鼛鼗齫鼓龘齳鼐鼌 72 鼅鼥鼂齳鼁黿黽黺黹黸龍鼥鼂黷

黵黱黰黮鼞龯 https://www.phpmyadmin.net/

黙黕黒黑龯

  1. 齘齕齓齑齏齎齽齻
  2. 齟齝黏黍黉龃 MySQL 黙黕黷
  3. 黀齘齕 CSV SQL 麶麴龃龁
  4. 黀麶麰龃龁黹麮麬麪麧龯 CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX 鹹鹹
  5. 齽齻黉鹸鹵鹴鹱
  6. 鹭黉鼅麪麧鹬鹪 database layout 鹨鹧
  7. 齘齕 Query-by-example (QBE) 鹬鹪鹝鹙鹕鹒
  8. 鹐龃龁齾鹍鹊龍鹆鹅鹃齉齆鹁鹀鸽鸼
  9. 龘鸸鸵鸳龍鸰龃鸮鸬鸫龍龃龁鸨鸦鸤鼩鼦麪麧

鸣鸟鸞鸛龯

V4.7.3 2017 8 9 鸅鸁齳鷿鷻鷷鷵鷴鷳 18 鸏鼛

鷯鷬龯

鸛鷯鷬龙鷩齋齫鸣鸟鸞鸛鷥鼂龯

PHP 5.5.0 鹍鷝鷚

龃龁齾龯齟齝 MySQL 鷘鷖鷔龃龁齾龯 MySQL 5.5 鹍鷝鷚齳 MariaDB 5.5 鹍鷝鷚

鷐鷎鹱龯龔鷍 cookies JavaScript 齟齝

鷄鷂龯

黰黮龯 https://www.phpmyadmin.net/

黵齓黺鹃鶾鷳鶽鷚龍鶺鸵鸞鷄鷂齳鶶鶵鶴龔鶱鷄鷂齳鶯鶫麰鶨鹸鼐鶧鶦齳鼐鶧鶣鷄鷂鶡鸤鶠齉齆鶜齡鶡鶚鶖鶔鶒齳鼐鼌鼛 SHA256 鶐鶎鶌齳鶉鶆鶣鶅鶂鵿鵻鹁齳鵸齉齆鶔鶒鵶鵵鼲鵲鵮鶣鵫鷻鷷鵧鵦齳 phpMyAdmin 龙龔齪鵥鵢龍齳鵟龐鵛鼮鵚鵙黍鵗齳鶉鶆鶣鵓齳鵑鶶鶵 Donate to phpMyAdmin 鵎鵋齉齆鵧鵦齳鵊鵇鶶鶵 Close 鵎鵋鵄鵃黷

鵻鴿龯

鴽鴻鷄鷂龍鶜齡齳鶴鵚黹鶨鹸鴺鴷 phpMyAdmin-4.7.3-all-languages 龍鶜齡鴲齳鸮鴰齎龍鶜齡鴭麴鷯鵟鴪鴩龍 web 鷷鴧鴦黀黷

龘齚麷鴣鴧龯

鵻鴿鶠鹐鷐鷎鹱鴟鴪鴩鷿鷷鴧鵑黕鴜鶧鴣鴧齏齎鼛齳鴛鴣鴧鸟鷯鵟鴙齉齆鴕鴓鸓鴒鷄鶜鸁齳鶅黉鴎鴊鹭齻鴽 phpMyAdmin 龘齚龍黒鴇龯鸣龘齚鴣鴧黹 phpMyAdmin 鴅齳龘齚鴄麷鴂鴀龙鳽鳻鳹龐鳸黹 MySQL 龍齳齧鳵龍鴕鴓鶜齡黀鹭鳳鷯鵟鸬鸫鳲鳯齳鳭鳳鹪鳫鸬鸫黷 phpMyAdmin 鸛鳵鶯鳳齽齻鼩鳪龘齚鸓鴛鷳鷩鳦鳤鳠龍龘齚黀鹭齘齕 phpMyAdmin 齽齻 MySQL 龘齚 ) 鵶鳝鷳龘齚鳚鳙鳘龙鷳鳖龍 MySQL 龘齚黷

鴕鴓龯

鳔鹐 phpMyAdmin 鼳鼛鼐鼌鳑鳏黱麧龍鴕鴓鼲鼮鼐鼌齓齑鵫麶麧龍鴕鴓齳鳎鷯鵟鳊鳈鶨鴦黀龯

鵫麶鴕鴓龯

齦齫鵻鹁鳆鳅齳鵫麶鳃鳁鳳鶴鹐鵻鴿鷷鴧鷄鲿鲼鼩鳪鶜齡齳鴕鴓鶡鸤鶠鷯鵟鷄鷂鴕鴓鶜齡鶯鲻黹 phpMyAdmin 龍鲷鲴鷷鴧鲰齳龔鶱鸟齳鶉鶆鷵鷴齘齕鳑鳏鴕鴓鲿鲼鼛 config.inc.php 鶜齡齳鷯鵟鴙鲫鼳 鵶鴪鴩 phpMyAdmin 鷷鴧鷄龍 setup 鹆鷷鴧鸓 url 鲪鹃 /setup/ 鶠鲦鸁齳鹐鲢鳈鷻齉齆鲞鴓鶠鶶鶵鳦龘齳鹁鲝鴕鴓鶡鸤鶠鲜黹黒鵟齑齎齳鶶鶵齑齎鲛鲝龍鴜鶧鵎鵋黀鹭鹕鲗鲼鸤龍鴕鴓鲰鷖齳鶶鶵鷄鷂鵎鵋齳鶴鷄鷂鶨鹸 config.inc.php 鶜齡齳鸮鳲鲻麴 phpMyAdmin 龍鲷鲴鷷鴧鴦黀齳鶉鶆鹭鶠鳳鶴鲔龘鵫麶鳃鳁齳黀鹭鸮 setup 鷷鴧鲫鼳黷

鳑鳏鴕鴓龯

鹐鲷鲴鷷鴧鷄鲑黹 config.sample.inc.php 鶜齡齳鹝鲎鶨鲊齳鲇鴄鼞龯 config.inc.php 齳麮鵑龙鲄鳯鵟鲂鲇龍鴕鴓鶜齡齳鹊龙鶨鹸 php 鳃鳁鶜齡齳鷯鵟鱾鱺 php 鼥鱹齳鼓龘鹁鹀鴄鱷鱵鱲齳鴰齎龍 $cfg 鱮鱬龙鹁鹀鴕鴓鱮鱬鵶鱨鱧鱤鴙鲪鷂鱨鱧鱣鱠鴕鴓鶜齡 libraries/config.default.php 齳鱞鶠鲪鷂龘齚鴕鴓鶜齡 config.inc.php 齳鳝鹭龘齚鴕鴓鶜齡龍鶌鶴鱜鱙鱣鱠鴕鴓齳鸣鳳鷯鵟鲂鲇鱖鱣鱠鴕鴓鶌鴅齳鳲鳯鳳鷯鵟麰鳔鹐龘齚鴕鴓鶜齡鴟齳龘齚鳳鵟鱔鲂鲇鱨鱧鱣鱠鴕鴓鶜齡齳鱣鱠鴕鴓鶜齡鱒麰鼛鳝鷳龍鴕鴓麷鱏鱋鱊黷

鳎鷯鵟齉齆鱈鸛鴕鴓鵑黀鹭鼓龘龯

$cfg['Servers'][$i]['host'] = 'localhost'; // 鰻鸵龃龁齾黰黮

$cfg['blowfish_secret'] = 'l7-~r*K\'M=S/.B0{g{;?6,%EW7`Qyr'; // 鰻鸵鶨鹸龘齫鲪鴂 cookie 龍鴂鴀

鸮鹭鹃鴕鴓鰠鲪黹 config.inc.php 鶜齡龍鰜鰙鰘鸫鴦黀齳鴣鴧鴅鰔麴龃龁齾龍龘齚鴄麷鴂鴀鵶齘鰒鰑鰐鷄鲄鳯鳎鷯鵟鰠鲪鹭鹃鴕鴓鴦鶡鸤鴕鴓黷

鷄齎鱒麰鷝黉鰒龘鴕鴓龯

$cfg['blowfish_secret'] = '1{dg0`<Q),5XP_:R9UKjhd%8\"EEsyH#{o'; // 鲞鴓 cookie 鲪鴂鴂鴀齳鶨鸵鵟齧鯿鲇

$cfg['DefaultLang'] = 'zh_cn'; // 鼓龘龶鯼鴟鶜齳鱣鱠鯸龘鷐鷎鹱龍鼥鼂

// 鹭鹃龙齣齡鴕鴓齳鹭鷄龙龃龁齾鹵鹴鹱鯵鯲鴕鴓

$cfg['Servers'][$i]['verbose'] = ' 鸛黰鹵鹴鹱 '; // 鯰龃龁齾鯭鶨鹸鴄鱷齳齽齻黉鹸鴅鼗齫鯪鯦

$cfg['Servers'][$i]['host'] = 'localhost'; // 龃龁齾黰黮齳龙鳙鯤龍齳鱣鱠鼞 'localhost'

$cfg['Servers'][$i]['port'] = '3306'; // 鯡鯠鯟齳鱣鱠 3306

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // 齓齑鴣鴧龍鱠鶒黱麧齳鱣鱠鼞 cookie 齳鴒鷄鶜

$cfg['Servers'][$i]['user'] = 'root'; // 龃龁齾龘齚鴄齳鯞龁鱠鶒黱麧鷥鸵齳黀鯛鯗鷿齆齳鴣鴧鴅鶴鯤鱙

$cfg['Servers'][$i]['password'] = 'mima'; // 龃龁齾鴂鴀齳鯓鹃齳鳳鹪鳫鯤鱙

$cfg['Servers'][$i]['AllowNoPassword'] = true; // 龙鵊鯏鯍鱵鴂鴀

// 鶉鶆鷳黉鹸龃龁齾鵟齽齻黀鹭鯌鲪鹭鷄鴕鴓齳鹐鴣鴧齑齎鶴鯉龘齚鳈鯇

$i++; // 鷿齆鶨鸵鳳黕鳽鯅鯗

$cfg['Servers'][$i]['verbose'] = ' 鯁鳊鹸鹵鹴鹱 ';

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

$cfg['Servers'][$i]['port'] = '';

$cfg['Servers'][$i]['socket'] = '';

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

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = 'mima';

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

鷝黉鴕鴓鵸鴒鷄鶜鹍鶜鮿鮻鰻鮷

鮵鮳鴕鴓龯

鹭鷄鱒麰鲄鳯鶽鰒龘龍鴕鴓齳黽鸛鶜鮿鹝鲎鮯鮭黹 config.inc.php 鰜鰙 鴦黀鮫鮪鶡鸤鲞鴓齳黱鼗龔龐鮦鼓龘龯

$cfg['blowfish_secret'] = '1{dg0`<Q),5XP_:R9UKjhd%8\"EEsyH#{o'; // 鲞鴓 cookie 鲪鴂鴂鴀齳鶨鸵鵟鲂鲇

$cfg['DefaultLang'] = 'zh_cn'; // 鼓龘龶鯼鴟鶜齳鱣鱠鯸龘鷐鷎鹱龍鼥鼂

$cfg['LoginCookieValidity'] = 86400; // 鹵鹴鹱鰘鸫龍鴣鴧鷳鳖鴅鱲齳鱣鱠鼞 1440 鮤齳麮鴰鲞鴓鼞鶨鮡

/**** 鹭鹃鼞齣齡鴕鴓齳鹭鷄鼞龃龁齾鴕鴓 ****/

$cfg['Servers'][$i]['host'] = 'localhost'; // 龃龁齾黰黮齳龙鳙鯤龍齳鱣鱠鼞 'localhost'

鶜鮿黰黮龯

鶶鶵 https://www.phpmyadmin.net/docs/ 鮟龔鶠黀鹭鲗黹鮞鶜鸞鸛龍黵黱鶜鮿齳鵵鼲鹐 Localized Documentation 鷄齎鷳鮜鮘鸞鸛龍鶜鮿齳鶶鶵 Chinese (Simplified) 黀鹭鮟龔龶鯼鴟鶜龍鶜鮿齑齎齳鴛鱏鴟鷳鲝鮖鶯鮔鷳鳽鮜鮘齳鳳龙鮑鹁齳鮏鮌鮊鮇鮜鮘龍鴎鳯齳鵲鵮黍鵗鮊鮇鮜鮘鵶鹐鶜鮿鴰齎龲鮆鼛 phpMyAdmin 黱黱齎齎龍鮅鯪黷

鰒龘鴕鴓鮄鸳龯

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

黀鹭鳈鯇鹭鷄鶌龯

cookie 龯麷鰒鮁齓魿鴣鴧鶨魻齳鴣鴧鶠龘 cookie 鼷鼞鳵鲊鱠鶒

config 龯鴣鴧鴅鳳鵟鷬鰔麴龘齚鴄鴂鴀齳鳻鳹鼓龘鴕鴓鶜齡魺鳹龃龁齾齳鳅鵵鴕鴓鶜齡鵻鹁鶅鵿鵟

http 龯龘 http 魹鳫鼐鼌龍鱠鶒黱麧齳鶂魶鴣鴧鳳黱鼗齳鶨魳鳳鼓龘

signon 龯鼓龘鯁魱黱鳦龘魯鳤鴣鴧齳鷯鵟鲞鴓鱏鳲鳈鷻魬鴕鱺

HTTP cookie 鱠鶒黱麧鷄齳魫鳳鷯鵟鯤鱙 $cfg['Servers'] 鴟龍 user/password 鲞鴓黷

$cfg['blowfish_secret']

cookie 鱠鶒黱麧鴟齳龘齚鴄麷鴂鴀鳽鸬鸫鹐 cookie 鴟齳齘齕 AES 鲪鴂齳龘麮鹸鳈鷻鼷鼞鲪鴂鴂鴀齳鳦鷿鼓龘 32 鱷鱾鹍鷝魨龍鴂鴀齳鴛鳳魤鲎齳鳳魡龍魠鶴麶魞魛鵻鹁齳麮鹸鳈鷻龍魘鴄鷳魗魕鳆鳅齳鶽魓 phpMyAdmin 龙鯸龘 Blowfish 魒鱹魬鲪鴂龍

$cfg['Servers'][$i]['socket']

魺鳹黹 MySQL 鹵鹴鹱魫黀鹭鳈鯇 'socket' 'tcp' 黷鱣鱠鼞 tcp 齳鳅鼞魑魏鳝鷳龍 MySQL 鹵鹴鹱鳚齟齝 tcp 齳鷥鷳麬魎魍龙鳳齟齝魉鳹鱷龍黷鵟鼓龘魉鳹鱷黱麧魺鳹齳魫龍 MySQL 鹵鹴鹱鳙鳘麷齓魿鹵鹴鹱鹐鯓鶨魍鹵鹴鹱鹃黷

$cfg['Servers'][$i]['controlhost']

鲞鴓鼓龘鶨鹸鱏鹊龍魆魄魬鰘鸫魀鲴黙黕龍龃龁齳鶨魳龘鳳黹黷

$cfg['Servers'][$i]['verbose']

鬼鹐齘齕 phpMyAdmin 齽齻黉鹸鹵鹴鹱鴅鷳龘黷魆齑龍鷄鬹鬷鬴鴟鸮龘鵵鶌鬰鬮魆魄鴄齳鳳鼐鼌鵇鯸龘魆魄鴄

$cfg['LoginCookieStore']

鲞鴓 cookie 鳽鷐鷎鹱鰘鸫龍鴅鱲齳鱣鱠鼞 0 齳鵄鵃齑齎鴦鲫鼳

$cfg['LoginCookieValidity'] = 1440;

鹐鹵鹴鹱鹃鴣鴧鯵鯲鳽鰘鸫龍鴅鱲齳鬭齕鸮鼐鶧鲔鬪鴣鴧齳鱣鱠鼞 1440

鷝黉鳈鷻鵸鲗龯 https://docs.phpmyadmin.net/zh_CN/latest/config.html

评论 (写第一个评论)