安置phpMyAdmin来管理Mysql数据库

2024-07-24 12:34:52

字体：大中小

来源：转载

供稿：网友

进行安装，默认是安装在/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数据库。配置好后就可以在选择增加的数据库了。

（编辑：武林网）

上一篇：MySQL数据库误操作后快速回滚的方式

下一篇：不重开mysql情况修改参数变量