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

评论 (写第一个评论)