首頁 > 運營 > 幫助中心 > 正文

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';

(編輯:錯新網)

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
金玫玫床戏