Windows环境下phpMyAdmin的安装配置办法
发布时间：2022-06-29 13:24:56 所属栏目：MySql教程 来源：互联网
导读：phpMyAdmin是一款很受欢迎的MySQL管理工具，Windows下的安装配置方法 启动的Apache过程中，有时候因为监听端口冲突，会报错而启动失败，类似的错误信息如下： 17:09:04 [Apache] Error: Apache shutdown unexpectedly. 17:09:04 [Apache] This may be due
|
phpMyAdmin是一款很受欢迎的MySQL管理工具，Windows下的安装配置方法 启动的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 mware-hostd.exe" -u "C:ProgramDataVMwarehostdconfig.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 修改监听的端口 # # When we also provide SSL we have to listen to the # standard HTTP port (see above) and to the HTTPS port # Listen 4450 默认连接的是本地的MySQL服务器，如果我们想连接多台MySQL服务器，可以编辑F: mppphpMyAdmin目录下的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'; （编辑：永州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐