安裝phpMyAdmin來管理Mysql資料庫
在下載 xampp安裝包,一鍵安裝最簡單。
進行安裝,預設是安裝在/opt目錄下。
[root@D2-AMLUATdb61 ~]# chmod 755 xampp-linux-x64-7.1.4-0-installer.run
[root@D2-AMLUATdb61 ~]# ./xampp-linux-x64-7.1.4-0-installer.run
修改配置檔案/opt/lampp/etc/extra/httpd-xampp.conf,增加Require all granted。
[root@D2-AMLUATdb61 ~]# vim /opt/lampp/etc/extra/httpd-xampp.conf
[root@D2-AMLUATdb61 ~]# grep -C 3 "Require all granted" /opt/lampp/etc/extra/httpd-xampp.conf
AllowOverride AuthConfig Limit
Require local
Require all granted
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
啟動xampp。
[root@D2-AMLUATdb61 ~]# /opt/lampp/xampp start
Starting XAMPP for Linux 7.1.4-0...
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...fail.
XAMPP: Another FTP daemon is already running.
在瀏覽器輸入IP地址後只能看到本地的mysql資料庫。
要管理其他的資料庫,需要修改配置檔案/opt/lampp/phpmyadmin/config.inc.php。
[root@D2-AMLUATdb61 ~]# cp /opt/lampp/phpmyadmin/config.inc.php /opt/lampp/phpmyadmin/config.inc.php.bak
[root@D2-AMLUATdb61 ~]# vim /opt/lampp/phpmyadmin/config.inc.php
[root@D2-AMLUATdb61 ~]# cat /opt/lampp/phpmyadmin/config.inc.php
<!--?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in documentation in the doc/ folder
* or at .
*
* @package PhpMyAdmin
*/
/**
* This is needed for cookie based authentication to encrypt password in
* cookie. Needs to be 32 chars long.
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */
/**
* Servers configuration
*/
$i = 0;
/**
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/**
* phpMyAdmin configuration storage settings.
*/
/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
/* Storage database and tables */
$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]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$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_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $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';
/**
* End of servers configuration
*/
/**
* Second server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123456';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '10.163.84.16';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/**
* phpMyAdmin configuration storage settings.
*/
/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
/* Storage database and tables */
$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]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$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_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $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';
/**
* End of servers 2 configuration
*/
上面增加的紅色部分表示增加一個被管理的Mysql資料庫。配置好後就可以在選擇增加的資料庫了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28536251/viewspace-2139304/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於 phpMyAdmin 管理 Homestead MySQL 資料庫的配置PHPMySql資料庫
- PHP、MySQL、phpmyadmin的安裝PHPMySql
- IIS+PHP+MySQL+ZendOptimizer+GD庫+phpMyAdmin安裝配置PHPMySql
- Ubuntu安裝MySQL資料庫UbuntuMySql資料庫
- 資料庫 之 管理工具 phpMyadmin資料庫PHP
- MySQL資料庫安裝步驟-WindowsMySql資料庫Windows
- 下載和安裝MySQL資料庫MySql資料庫
- Linux下安裝Mysql資料庫LinuxMySql資料庫
- win7安裝MySQL資料庫Win7MySql資料庫
- phpMyAdmin安裝PHP
- WINXP下安裝Apache,PHP,MySQL,phpMyAdmin薦ApachePHPMySql
- MySQL資料庫資料管理MySql資料庫
- 在FreeBSD中安裝MySQL資料庫MySql資料庫
- 01 MySQL資料庫安裝(Windows+Mac)MySql資料庫WindowsMac
- hive的安裝(後設資料庫: MySQL)Hive資料庫MySql
- MySQL資料庫下載及安裝教程MySql資料庫
- PostgreSQL資料庫管理系列之一——安裝SQL資料庫
- 安裝與配置MySQL,phpmyAdmin;安裝與測試PHPLIB (轉)MySqlPHP
- CentOS7離線安裝(rpm安裝)mysql資料庫CentOSMySql資料庫
- MySQL資料庫管理4MySql資料庫
- Mysql8.0.17資料庫安裝圖文教程MySql資料庫
- WINDOWS下安裝MYSQL資料庫教程詳解WindowsMySql資料庫
- Openfire安裝準備-MySQL資料庫準備MySql資料庫
- Ubuntu下Mysql資料庫的安裝和使用UbuntuMySql資料庫
- CentOS下Mysql資料庫的安裝與配置CentOSMySql資料庫
- mysql資料庫的安裝(圖文詳解)MySql資料庫
- OCP課程24:管理Ⅰ之資料庫安裝資料庫
- 【MySQL資料庫】MySQL5.7安裝與配置、視覺化工具安裝和破解MySql資料庫視覺化
- Linux/Centos安裝Litespeed+PHP+MYSQL+PHPMYADMIN教程LinuxCentOSPHPMySql
- 使用 phpMyAdmin 管理多臺 MySQLPHPMySql
- Bash 指令碼安裝 MySQL-8.0.20 資料庫指令碼MySql資料庫
- Ubuntu安裝MySQL如何設定資料庫密碼UbuntuMySql資料庫密碼
- 如何在FreeBSD 13中安裝MySQL資料庫MySql資料庫
- 資料庫mysql8.0.22的安裝與使用資料庫MySql
- 安裝mysql資料庫及問題解決方法MySql資料庫
- MySQL資料庫安裝,配置My.ini檔案MySql資料庫
- mysql5.0資料庫原始碼編譯安裝MySql資料庫原始碼編譯
- linux下如何完全解除安裝mysql資料庫LinuxMySql資料庫