首页 > 运营 > 帮助中心 > 正文

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

2022-07-16 17:15:38
字体:
来源:转载
供稿:网友
  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';

(编辑:错新网)

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表