亚洲激情专区-91九色丨porny丨老师-久久久久久久女国产乱让韩-国产精品午夜小视频观看

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

Windows環境下phpMyAdmin的安裝配置方法

發布時間:2020-08-04 23:41:56 來源:ITPUB博客 閱讀:371 作者:feelpurple 欄目:MySQL數據庫
phpMyAdmin是一款很受歡迎的MySQL管理工具,Windows下的安裝配置方法如下:

XAMPP,里面會有配置好的phpMyAdmin環境
https://www.apachefriends.org/index.html

下載好安裝包后,直接安裝

安裝完成后,會自動彈出控制臺窗口,在以后的使用中,可以點擊安裝目錄下面的控制臺執行程序來啟動控制臺
xampp-control.exe

點擊Apache和MySQL模塊后的Start按鈕來啟動服務

Windows環境下phpMyAdmin的安裝配置方法

啟動的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
Windows環境下phpMyAdmin的安裝配置方法

修改監聽的端口
#
# 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

Windows環境下phpMyAdmin的安裝配置方法


點擊頁面右上角的phpMyAdmin

Windows環境下phpMyAdmin的安裝配置方法

默認是不需要密碼,即可連接到數據庫;如果修改了root用戶的密碼,則需要編輯F:\xampp\phpMyAdmin目錄下的config.inc.php文件,更改里面的連接密碼
Windows環境下phpMyAdmin的安裝配置方法

默認連接的是本地的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頁面后,可以選擇兩個數據庫
Windows環境下phpMyAdmin的安裝配置方法
向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

三河市| 汶川县| 胶南市| 天津市| 如东县| 专栏| 鄂州市| 梨树县| 长岭县| 青阳县| 浦江县| 专栏| 团风县| 绥中县| 于田县| 南江县| 梅河口市| 桃源县| 德安县| 北安市| 平山县| 年辖:市辖区| 赣州市| 神池县| 金塔县| 高邑县| 仪陇县| 越西县| 修文县| 肃北| 美姑县| 新蔡县| 营口市| 诸暨市| 砀山县| 黑龙江省| 从江县| 武强县| 即墨市| 嘉定区| 宝清县|