在网上看到Mysql数据库的B/S管理工具phpmyadmin,就想看看怎么用。到网上下载相关软件和资料,然后开始了折腾,最后发现网上的资料,都是根据自己需要,把自己经验总结一下,看起来虽然很好,参考起来比较艰难,在经过了多次百度谷歌后,把自己配置的经验放在这里,供自己日后参考。
首先需要的软件及下载地址:
PHP VC9 x86 Thread Safe 软件:http://windows.php.net/download/ 下载线程安全版;
其次始软件的安装。
一、安装Appache,安装到Servers Information 时,需要输入邮箱地址,方可继续安装;
二、安装PHP;
三、安装phpmyadmin;
四、安装Mysql;
然后开始配置:
一、appache的配置httpd.conf
监听端口及PHPIni软件目录:
Listen 8888
PHPIniDir "D:/php" -------实验机上的php软件解压到D盘的PHP目录下;
phpmyadmin虚拟目录:
DocumentRoot "D:/Program Files/Apache Software Foundation/Apache2.2/htdocs"-------实验机上的phpmyadmin网站放此目录下;
支持网页文件的格式:
DirectoryIndex main.php index.php index.html
添加PHP文件的模块:
LoadModule php5_module "D:/php/php5apache2_2.dll"--------实验机上的php放在此目录下;
添加文件解析格式:
AddType application/x-gzip .tgz
AddType application/x-httpd-php .php .phtml .php3 .php4 .php5 .phpt
AddType application/x-httpd-php-source .phps
AddType application/x-httpd-php .txt
AddType application/x-httpd-php .html
更改完后,重新启动appache服务器;
二、PHP配置(把php.ini-development改为php.ini)
添加扩展类库:
extension_dir="D:\php\ext"
extension=modulename.extension
去掉类库的注释:
extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_gmp.dll
extension=php_intl.dll
extension=php_imap.dll
extension=php_interbase.dll
extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll ; Must be after mbstring as it depends on it
extension=php_mysql.dll
extension=php_mysqli.dll
extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
extension=php_openssl.dll
extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
extension=php_pdo_oci.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
extension=php_pgsql.dll
extension=php_pspell.dll
extension=php_shmop.dll
; The MIBS data available in the PHP distribution must be installed.
; See http://www.php.net/manual/en/snmp.installation.php
extension=php_snmp.dll
extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite3.dll
extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll
extension=php_zip.dll
启用对文件格式支持:
short_open_tag = On
; Allow ASP-style. tags.
; http://php.net/asp-tags
asp_tags = On
更改日期格式:
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone =prc
三、phpmyadmin配置(把config.sample.inc.php更改为config.inc.php)
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = '198228'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ ------更改对cookie 的认证
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controluser'] = 'root';-------安装Mysql的时候设置的用户名
$cfg['Servers'][$i]['controlpass'] = 'root';------安装Mysql的时候设置的密码
最后输入http://localhost:8888,打开网页,能进行登录即可。8888是监听端口。