CentOS 6 預設沒有 php-mcrypt 的問題(phpmyadmin 要用啦!!)
哪就用 EPEL 的好了...
rpm -ivh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-5.noarch.rpm另外 phpmyadmin 的 pma 進階功能安裝 ,說明如下(就是大家都不翻譯中文)
yum install php-mcrypt
/etc/init.d/httpd restart
http://xxx.xxx.xxx.tw/pma/Documentation.html#linked-tables
他就一直告訴你,你有個功能沒有裝,沒裝很可惜一直提醒....真是可惡...
開啟的方式很簡單
(1)建立一個MySQL使用者隨便取名字, ex: 帳號:pma 密碼:pmapass
(2)在 ./examplescreate_tables.sql 有建立表格的資訊,使用上面的帳號登入並把它擷取貼到 phpmyadmin 內的 sql 欄位並執行。
(3)修改系統的底下這段,把註解打開並改一下正確的帳號及密碼
/*
* phpMyAdmin configuration storage settings.
*/
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = 'localhost';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Storage database and tables */
$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]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';