Centos5下用 phpMyAdmin 让 MySQL 数据库管理温和化

前面安装好了mysql，不过是基于命令行的操作界面，对于非专业的用户使用起来 比较困难，那有没有简单点的图形界面了，phpmyadmin很好的解决了这个难题，不过phpMyAdmin存在的意义只是为了让MySQL的变的 让非专业人士更容易理解，其实质还是SQL命令的执行。

下面就来介绍下如何用 phpMyAdmin 让 MySQL 数据库管理温和化：

[root@centos5 /]# wget 　                                             --09:36:43-- 　
Resolving jaist.dl.sourceforge.net... 150.65.7.130
Connecting to jaist.dl.sourceforge.net|150.65.7.130|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3355025 (3.2M) [application/x-gzip]
Saving to: `phpMyAdmin-2.7.0-pl2.tar.gz'

100%[====================================================================================>] 3,355,025   6.20K/s   in 7m 5s

09:43:52 (7.70 KB/s) - `phpMyAdmin-2.7.0-pl2.tar.gz' saved [3355025/3355025]

移动并解压到用户的家目录
[root@centos5 /]# mv phpMyAdmin-2.7.0-pl2.tar.gz ~
[root@centos5 /]# cd ~
[root@centos5 /]#tar zxvf phpMyAdmin-2.7.0-pl2.tar.gz　

将解压出来的目录移动到/var/www目录下并改名为phpmyadmin
[root@centos5 ~]# mv phpMyAdmin-2.7.0-pl2 /var/www/phpmyadmin

[root@centos5 ~]# ls /var/www/phpmyadmin/
browse_foreigners.php        README
calendar.php                 readme.php
ChangeLog                    RELEASE-DATE-2.7.0-pl2
changelog.php                scripts
chk_rel.php                  server_binlog.php
config.default.php           server_collations.php
config.footer.inc.php        server_common.inc.php
config.header.inc.php        server_databases.php
CREDITS                      server_engines.php
css                          server_export.php
db_create.php                server_import.php
db_datadict.php              server_links.inc.php
db_details_common.php        server_privileges.php
db_details_db_info.php       server_processlist.php
db_details_export.php        server_sql.php
db_details_importdocsql.php server_status.php
db_details_links.php         server_variables.php
db_details.php               sql.php
db_details_qbe.php           tbl_addfield.php
db_details_structure.php     tbl_alter.php
db_import.php                tbl_change.php
db_operations.php            tbl_create.php
db_printview.php             tbl_import.php
db_search.php                tbl_indexes.php
docs.css                     tbl_move_copy.php
Documentation.html           tbl_printview.php
Documentation.txt            tbl_properties_common.php
error.php                    tbl_properties_export.php
export.php                   tbl_properties.inc.php
favicon.ico                  tbl_properties_links.php
footer.inc.php               tbl_properties_operations.php
header.inc.php               tbl_properties.php
header_printview.inc.php     tbl_properties_structure.php
import.php                   tbl_properties_table_info.php
index.php                    tbl_query_box.php
INSTALL                      tbl_relation.php
lang                         tbl_rename.php
left.php                     tbl_replace_fields.php
libraries                    tbl_replace.php
LICENSE                      tbl_row_action.php
license.php                  tbl_select.php
main.php                     themes
mult_submits.inc.php         themes.php
pdf_pages.php                TODO
pdf_schema.php               transformation_wrapper.php
phpinfo.php                  translators.html
querywindow.php              user_password.php

安装php-mbstring，让phpmyadmin能够正确识别字符串

[root@centos5 ~]# yum -y install php-mbstring
Loading "fastestmirror" plugin
Loading mirror speeds from cached hostfile
* base: centos.candishosting.com.cn
* updates: mirror.khlug.org
* addons: centos.candishosting.com.cn
* extras: centos.candishosting.com.cn
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package php-mbstring.i386 0:5.1.6-20.el5_2.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================
Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
php-mbstring            i386       5.1.6-20.el5_2.1 updates           969 k

Transaction Summary
=============================================================================
Install      1 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 969 k
Downloading Packages:
(1/1): php-mbstring-5.1.6 100% |=========================| 969 kB    00:39
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: php-mbstring                 ######################### [1/1]

Installed: php-mbstring.i386 0:5.1.6-20.el5_2.1
Complete!

复制默认文件模板到应用文件config.inc.php
[root@centos5 ~]# cp /var/www/phpmyadmin/config.default.php /var/www/phpmyadmin/config.inc.php
[root@centos5 ~]# chmod 660 /var/www/phpmyadmin/config.inc.php 改变其属性，使其具有可写性
[root@centos5 ~]# vi /var/www/phpmyadmin/config.inc.php

$cfg['blowfish_secret'] = '在此填入口令'; 　（这个口令只是程序内部使用，并非登录相关的口令。口令长 度限制在46个字符以内。）
$cfg['Servers'][$i]['auth_type'] = 'cookie'; （将原先的config改为cookie，使认证方式为cookie方式）

[root@centos5 ~]# chown -R root:apache /var/www/phpmyadmin/

[root@centos5 ~]# vi /etc/httpd/conf.d/phpmyadmin.conf 建立供Apache调用的phpMyAdmin配置文件
Alias /phpmyadmin /var/www/phpmyadmin

<Location /phpmyadmin>
Order deny,allow
Deny from all
Allow from 127.0.0.1
Allow from 192.168.0
</Location>

这里只允许本机和192.168.0.0/网段的主机访问，如果允许外网用户，请 不要填写<Location></Location>标签中的内容

[root@centos5 ~]# /etc/rc.d/init.d/httpd restart    重新启动HTTP服务，使以上设置生效

Stopping httpd:                                            [ OK ]
Starting httpd:                                            [ OK ]

接着就来测试下是否成功了，一开始输入(这里我的apache配置了SSL，服务器地址是200)，出现如下界面，感觉好像是成功了

可我接着输入用户名root和密码123后却没什么反应，反复检查还是觉得自己的 配置是正确的，无奈下只有Google下了，找了很多相关文章，还是没发现错误的地方，终于最后找到了一个和我一样的情况，他说他之前配置的时候也是这 样，检查再三发现自己的系统时间不对，我晕，我看看自己虚拟机的系统时间和真机差了几个小时，用date命令修改完后奇迹般的登陆成功了，狂晕！