Windows环境下phpMyAdmin的安装配置方法

- 日理万妓 2024-04-17 23:58 3阅读 0赞

phpMyAdmin是一款很受欢迎的MySQL管理工具，Windows下的安装配置方法如下：  
  
**去** **下** **载** **X** **A** **M** **P** **P** **包** **，里面会有配置好的** **phpMyAdmin环境**  
https://www.apachefriends.org/index.html  
  
下载好安装包后，直接安装  
  
安装完成后，会自动弹出控制台窗口，在以后的使用中，可以点击安装目录下面的控制台执行程序来启动控制台  
 **xampp-control.exe**   
  
**点击Apache和MySQL模块后的Start按钮来启动服务**  
![Image 1][]  
  
启动的Apache过程中，有时候因为监听端口冲突，会报错而启动失败，类似的错误信息如下：  
17:09:04  \[Apache\] Error: Apache shutdown unexpectedly.  
17:09:04  \[Apache\] This may be due to a blocked port, missing dependencies,   
17:09:04  \[Apache\] improper privileges, a crash, or a shutdown by another method.  
17:09:04  \[Apache\] Press the Logs button to view error logs and check  
17:09:04  \[Apache\] the Windows Event Viewer for more clues  
17:09:04  \[Apache\] If you need more help, copy and post this  
17:09:04  \[Apache\] entire log window on the forums  
17:09:12  \[Apache\] Problem detected!  
17:09:12  \[Apache\] Port 443 in use by ""E:\\Program Files (x86)\\VMware Workstation\\vmware-hostd.exe" -u "C:\\ProgramData\\VMware\\hostd\\config.xml"" with PID 2952!  
17:09:12  \[Apache\] Apache WILL NOT start without the configured ports free!  
17:09:12  \[Apache\] You need to uninstall/disable/reconfigure the blocking application  
17:09:12  \[Apache\] or reconfigure Apache and the Control Panel to listen on a different port  
  
**对于这个错误，解决方法是** **更换监听的端口，点击进行Apache配置文件httpd-ssl.conf**  
![Image 1][]  
  
修改监听的端口  
\#  
\# When we also provide SSL we have to listen to the   
\# standard HTTP port (see above) and to the HTTPS port  
\#  
**Listen 4450**  
  
  
\#\#  
  
修改端口后，再次启动Apache，直到正常启动  
  
**Apache和MySQL服务均成功启动后，通过本地网页进入管理界面  
http://192.168.8.99**  
![Image 1][]  
  
  
**点击页面右上角的phpMyAdmin**  
  
![Image 1][]  
  
默认是不需要密码，即可连接到数据库；如果修改了root用户的密码，则需要编辑F:\\xampp\\phpMyAdmin目录下的config.inc.php文件，更改里面的连接密码  
![Image 1][]  
  
**默认连接的是本地的MySQL服务器，如果我们想连接多台MySQL服务器，可以** **编辑** **F:\\xampp\\phpMyAdmin** **目录下的** **config.inc.php文件，增加数据库。**  
**下面配置参数中，** **second server是仿照first server增加的数据库配置文件。**  
  
<?php  
/\*  
 \* This is needed for cookie based authentication to encrypt password in  
 \* cookie  
 \*/  
$cfg\['blowfish\_secret'\] = 'xampp'; /\* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! \*/  
  
/\*  
 \* Servers configuration  
 \*/  
$i = 0;  
  
/\*  
 \* First server  
 \*/  
$i++;  
  
/\* Authentication type and info \*/  
$cfg\['Servers'\]\[$i\]\['auth\_type'\] = 'config';  
$cfg\['Servers'\]\[$i\]\['user'\] = 'root';  
$cfg\['Servers'\]\[$i\]\['password'\] = 'root';  
$cfg\['Servers'\]\[$i\]\['extension'\] = 'mysqli';  
$cfg\['Servers'\]\[$i\]\['AllowNoPassword'\] = true;  
$cfg\['Lang'\] = '';  
  
/\* Bind to the localhost ipv4 address and tcp \*/  
$cfg\['Servers'\]\[$i\]\['host'\] = '127.0.0.1';  
$cfg\['Servers'\]\[$i\]\['connect\_type'\] = 'tcp';  
  
/\* User for advanced features \*/  
$cfg\['Servers'\]\[$i\]\['controluser'\] = 'pma';  
$cfg\['Servers'\]\[$i\]\['controlpass'\] = '';  
  
/\* Advanced phpMyAdmin features \*/  
$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\]\['designer\_coords'\] = 'pma\_\_designer\_coords';  
$cfg\['Servers'\]\[$i\]\['tracking'\] = 'pma\_\_tracking';  
$cfg\['Servers'\]\[$i\]\['userconfig'\] = 'pma\_\_userconfig';  
$cfg\['Servers'\]\[$i\]\['recent'\] = 'pma\_\_recent';  
$cfg\['Servers'\]\[$i\]\['table\_uiprefs'\] = 'pma\_\_table\_uiprefs';  
$cfg\['Servers'\]\[$i\]\['users'\] = 'pma\_\_users';  
$cfg\['Servers'\]\[$i\]\['usergroups'\] = 'pma\_\_usergroups';  
$cfg\['Servers'\]\[$i\]\['navigationhiding'\] = 'pma\_\_navigationhiding';  
$cfg\['Servers'\]\[$i\]\['savedsearches'\] = 'pma\_\_savedsearches';  
$cfg\['Servers'\]\[$i\]\['central\_columns'\] = 'pma\_\_central\_columns';  
$cfg\['Servers'\]\[$i\]\['designer\_settings'\] = 'pma\_\_designer\_settings';  
$cfg\['Servers'\]\[$i\]\['export\_templates'\] = 'pma\_\_export\_templates';  
$cfg\['Servers'\]\[$i\]\['favorite'\] = 'pma\_\_favorite';  
  
/\*  
 \* **second server**  
 \*/  
$i++;  
  
/\* Authentication type and info \*/  
$cfg\['Servers'\]\[$i\]\['auth\_type'\] = 'config';  
**$cfg\['Servers'\]\[$i\]\['user'\] = 'neo';**  
**$cfg\['Servers'\]\[$i\]\['password'\] = 'neo';**  
$cfg\['Servers'\]\[$i\]\['extension'\] = 'mysqli';  
$cfg\['Servers'\]\[$i\]\['AllowNoPassword'\] = true;  
$cfg\['Lang'\] = '';  
  
/\* Bind to the localhost ipv4 address and tcp \*/  
**$cfg\['Servers'\]\[$i\]\['host'\] = '127.0.0.1';**  
$cfg\['Servers'\]\[$i\]\['connect\_type'\] = 'tcp';  
  
/\* User for advanced features \*/  
$cfg\['Servers'\]\[$i\]\['controluser'\] = 'pma';  
$cfg\['Servers'\]\[$i\]\['controlpass'\] = '';  
  
/\* Advanced phpMyAdmin features \*/  
$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\]\['designer\_coords'\] = 'pma\_\_designer\_coords';  
$cfg\['Servers'\]\[$i\]\['tracking'\] = 'pma\_\_tracking';  
$cfg\['Servers'\]\[$i\]\['userconfig'\] = 'pma\_\_userconfig';  
$cfg\['Servers'\]\[$i\]\['recent'\] = 'pma\_\_recent';  
$cfg\['Servers'\]\[$i\]\['table\_uiprefs'\] = 'pma\_\_table\_uiprefs';  
$cfg\['Servers'\]\[$i\]\['users'\] = 'pma\_\_users';  
$cfg\['Servers'\]\[$i\]\['usergroups'\] = 'pma\_\_usergroups';  
$cfg\['Servers'\]\[$i\]\['navigationhiding'\] = 'pma\_\_navigationhiding';  
$cfg\['Servers'\]\[$i\]\['savedsearches'\] = 'pma\_\_savedsearches';  
$cfg\['Servers'\]\[$i\]\['central\_columns'\] = 'pma\_\_central\_columns';  
$cfg\['Servers'\]\[$i\]\['designer\_settings'\] = 'pma\_\_designer\_settings';  
$cfg\['Servers'\]\[$i\]\['export\_templates'\] = 'pma\_\_export\_templates';  
$cfg\['Servers'\]\[$i\]\['favorite'\] = 'pma\_\_favorite';  
  
/\*  
 \* End of servers configuration  
 \*/  
  
?>  
  
这样，在打开phpMyAdmin页面后，可以选择两个数据库  
![Image 1][]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2094504/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2094504/

[Image 1]: