CentOS6.5 安裝phpMyAdmin

一、安裝phpMyAdmin

phpMyAdmin 對應 php 版本會有影響，請挑選適合的版本

wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.1.12/phpMyAdmin-4.1.12-all-languages.tar.gz

tar -zxvf phpMyAdmin-4.1.12-all-languages.tar.gz

mv phpMyAdmin-4.1.12-all-languages /usr/share/nginx/html/phpMyAdmin

rm phpMyAdmin-4.1.12-all-languages.tar.gz

路徑:/usr/share/nginx/html/phpMyAdmin
複製範本設定檔 config.sample.inc.php 並重新命名為 config.inc.php

cp config.sample.inc.php config.inc.php

 /* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookies';

改成

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';

mysql -u root -p -h 127.0.0.1

mysql> select user, host from mysql.user;

mysql> create user 'admin'@'%' identified by 'admin';

mysql> grant all on *.* to 'admin'@'%';

這樣 admin 對整個資料庫的所有資料表都擁有全部的權利

建立使用者pma
mysql> create user 'pma'@'localhost' identified by 'pmapass';
給予pma表phpmyadmin權限
mysql> grant select, insert, update, delete on phpmyadmin.* to pma@localhost;

執行create_tables.sql啟用高級功能
mysql -u root -p < /usr/share/nginx/html/phpMyAdmin/examples/create_tables.sql