安装phpMyAdmin来管理Mysql数据库

在https://www.apachefriends.org/download.html下载 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数据库。配置好后就可以在选择增加的数据库了。