• <optgroup id="qksf7"><xmp id="qksf7"><optgroup id="qksf7"></optgroup>
      
      
      <rp id="qksf7"><acronym id="qksf7"></acronym></rp><tbody id="qksf7"><track id="qksf7"><dl id="qksf7"></dl></track></tbody>
      首頁 > 運營 > 幫助中心 > 正文

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

      (編輯:錯新網)

      發表評論 共有條評論
      用戶名: 密碼:
      驗證碼: 匿名發表
      一级特黄大片欧美久久久久_一本一道久久综合狠狠老_JLZZ日本人年轻护士_欧美男男作爱VIDEOS可播放