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` 鲇鳿 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` 鲇鳿 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

评论 (写第一个评论)