【教學】^_^phpmyadmin 出現關聯資料表的附加功能未能啟動解決方法
我是用mysql寫入的因為我菜 這個方法也可以 我不會用phpmyadmin寫入 好吧 請看方式吧
1.建立一個資料庫
名稱hpmyadin
說明:先到phpmyadin,看到建立新資料庫,空白框鍵入phpmyadin
2.找到create_tables.sql
說明:檔案位址在phpmyadin目錄中的scripts文件夾,就看到
create_tables.sql檔案了
3.create_tables.sql檔copy到mysql目錄中的bin文件夾
4.用cmd模式進入bin目錄中
說明:C:\Documents and Settings\Administrator>cd\
C:\cd mysql\bin
C:\mysql\bin>
5.匯入create_tables.sql檔到phpmyadin資料庫中
說明:上面第四步驟,鍵入
C:\mysql\bin>mysql -uroot -p資料庫密碼 phpmyadin
<create_tables.sql
6.更改config.inc.php
說明:檔案在phpmyadin目錄下,以下為更改數據
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['relation'] = 'pma_relation'; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history'] = 'pma_history'; // table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
更改完成,回去看看吧,應該沒問題了
