[phpMyAdmin]關聯資料表的附加功能未能啟動
發表於 : 2010-06-02 15:13:29
1. 在phpMyAdmin 目錄底下有個 scripts 目錄裡面有個 create_tables.sql，找到之後把它倒進MyySQL
2. 建立一個MySQL 使用者叫做pma 並且給予phpmyadmin 資料庫有 SELECT, UPDATE, DELETE, FILE 權限
3. 修改 phpMyAdmin 底下 config.inc.php
找到以下區塊並拿掉註解
2. 建立一個MySQL 使用者叫做pma 並且給予phpmyadmin 資料庫有 SELECT, UPDATE, DELETE, FILE 權限
3. 修改 phpMyAdmin 底下 config.inc.php
找到以下區塊並拿掉註解
代碼: 選擇全部
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pma的密碼';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpMyAdmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$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]['history'] = 'pma_history';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';