實驗需求:在伺服器本機搭建mysql圖形管理工具
1.簡單部署lamp平台
# yum -y install httpd mysql mysql-server php php-mysql php-pdo
# rpm -ivh php-mbstring-5.3.3-26.el6.x86_64.rpm //此包安裝CD光牒沒有,需自己下載下傳
2.修改httpd配置檔案,啟動服務
# vim /etc/httpd/conf/httpd.conf
……
servername localhost.localdomain
directoryindex index.php index.html
# service httpd start
3.安裝phpmyadmin軟體包
# unzip phpmyadmin-4.1.2-all-languages.zip -d /var/www/html/ //解壓到網站目錄
# cd /var/www/html/
# mv phpmyadmin-4.1.2-all-languages/ phpmyadmin //改名友善登入
# cd phpmyadmin/
# cp config.sample.inc.php config.inc.php //建立主配置檔案
# vim config.inc.php
17 $cfg[‘blowfish_secret‘] = ‘jin123‘; /* you must fill in this for cookie auth! */ //随便寫幾個字元
31 $cfg[‘servers‘][$i][‘host‘] = ‘192.168.100.1‘; //本機ip
#若phpmyadmin軟體不是安裝在mysql伺服器本機上,則可填寫用戶端ip,但需在伺服器上先授權用戶端有登入mysql服務的權限
4.啟動服務
# service mysqld start
# service httpd restart
5.浏覽器登入
http://192.168.100.1/phpmyadmin