前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Install phpMyAdmin

Install phpMyAdmin

作者头像
franket
发布2021-08-11 09:38:59
2.9K0
发布2021-08-11 09:38:59
举报
文章被收录于专栏:技术杂记

前言

phpMyAdmin 是一个 php 写的 web 版 mysql 管理工具

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement

phpMyAdmin 可以完成常见的 mysql 管理工作

这里演示一下如何构建 phpMyAdmin 的过程

参考 phpMyAdmin文档How to install Apache, PHP 7.2 and MySQL on CentOS 7.4 (LAMP)

Tip: 当前的最新版为 phpMyAdmin 4.8.0


操作

OS 环境

代码语言:javascript
复制
[root@phpmyadmin ~]# cat /etc/centos-release
CentOS Linux release 7.4.1708 (Core) 
[root@phpmyadmin ~]# hostnamectl 
   Static hostname: phpmyadmin
         Icon name: computer-vm
           Chassis: vm
        Machine ID: 316348df30744c9c91b9202baf3915a6
           Boot ID: 0d7d6055ed704fb6a02a08745c3e5e91
    Virtualization: kvm
  Operating System: CentOS Linux 7 (Core)
       CPE OS Name: cpe:/o:centos:centos:7
            Kernel: Linux 3.10.0-693.21.1.el7.x86_64
      Architecture: x86-64
[root@phpmyadmin ~]# ip a 
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN qlen 1
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:8c:97:19 brd ff:ff:ff:ff:ff:ff
    inet 10.0.2.15/24 brd 10.0.2.255 scope global dynamic enp0s3
       valid_lft 84865sec preferred_lft 84865sec
    inet6 fe80::334c:bc63:1266:56b3/64 scope link 
       valid_lft forever preferred_lft forever
3: enp0s8: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP qlen 1000
    link/ether 08:00:27:ab:2c:0c brd ff:ff:ff:ff:ff:ff
    inet 192.168.56.213/24 brd 192.168.56.255 scope global enp0s8
       valid_lft forever preferred_lft forever
    inet6 fe80::2be7:a317:cc4b:666b/64 scope link 
       valid_lft forever preferred_lft forever
4: virbr0: <NO-CARRIER,BROADCAST,MULTICAST,UP> mtu 1500 qdisc noqueue state DOWN qlen 1000
    link/ether 52:54:00:14:54:5c brd ff:ff:ff:ff:ff:ff
    inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0
       valid_lft forever preferred_lft forever
5: virbr0-nic: <BROADCAST,MULTICAST> mtu 1500 qdisc pfifo_fast master virbr0 state DOWN qlen 1000
    link/ether 52:54:00:14:54:5c brd ff:ff:ff:ff:ff:ff
[root@phpmyadmin ~]# 

软件环境

代码语言:javascript
复制
[root@phpmyadmin ~]# systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since 日 2018-04-15 02:40:09 EDT; 43min ago
  Process: 1228 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 1164 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 1227 (mysqld_safe)
   CGroup: /system.slice/mariadb.service
           ├─1227 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─1456 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log...

4月 15 02:40:06 phpmyadmin systemd[1]: Starting MariaDB database server...
4月 15 02:40:07 phpmyadmin mariadb-prepare-db-dir[1164]: Database MariaDB is probably initialized in /var/lib/mysql...one.
4月 15 02:40:07 phpmyadmin mariadb-prepare-db-dir[1164]: If this is not the case, make sure the /var/lib/mysql is e...dir.
4月 15 02:40:07 phpmyadmin mysqld_safe[1227]: 180415 02:40:07 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
4月 15 02:40:07 phpmyadmin mysqld_safe[1227]: 180415 02:40:07 mysqld_safe Starting mysqld daemon with databases fr...mysql
4月 15 02:40:09 phpmyadmin systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@phpmyadmin ~]# systemctl status httpd.service
● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: active (running) since 日 2018-04-15 02:40:07 EDT; 43min ago
     Docs: man:httpd(8)
           man:apachectl(8)
 Main PID: 1181 (httpd)
   Status: "Total requests: 11; Current requests/sec: 0; Current traffic:   0 B/sec"
   CGroup: /system.slice/httpd.service
           ├─1181 /usr/sbin/httpd -DFOREGROUND
           ├─1414 /usr/sbin/httpd -DFOREGROUND
           ├─1415 /usr/sbin/httpd -DFOREGROUND
           ├─1416 /usr/sbin/httpd -DFOREGROUND
           ├─1417 /usr/sbin/httpd -DFOREGROUND
           ├─1418 /usr/sbin/httpd -DFOREGROUND
           ├─3305 /usr/sbin/httpd -DFOREGROUND
           ├─3306 /usr/sbin/httpd -DFOREGROUND
           └─3307 /usr/sbin/httpd -DFOREGROUND

4月 15 02:40:06 phpmyadmin systemd[1]: Starting The Apache HTTP Server...
4月 15 02:40:07 phpmyadmin httpd[1181]: AH00558: httpd: Could not reliably determine the server's fully qualified...essage
4月 15 02:40:07 phpmyadmin systemd[1]: Started The Apache HTTP Server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@phpmyadmin ~]#
[root@phpmyadmin ~]# php --version
PHP 7.2.4 (cli) (built: Mar 27 2018 17:23:35) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.4, Copyright (c) 1999-2018, by Zend Technologies
[root@phpmyadmin ~]#

其运行环境需要一个完整的 LAMP 环境,准确来讲,是一个 LAP 环境,而其中的 M(mysql) 就是被管理的对象

安装软件包

代码语言:javascript
复制
[root@phpmyadmin ~]#  rpm -qa | grep epel
epel-release-7-9.noarch
[root@phpmyadmin ~]# yum list all | grep phpMyAdmin
phpMyAdmin.noarch                        4.4.15.10-2.el7              epel      
[root@phpmyadmin ~]# yum install phpMyAdmin.noarch
Loaded plugins: fastestmirror, langpacks
base                                                                                                | 3.6 kB  00:00:00     
epel/x86_64/metalink                                                                                | 7.8 kB  00:00:00     
extras                                                                                              | 3.4 kB  00:00:00     
remi-php72                                                                                          | 2.9 kB  00:00:00     
remi-safe                                                                                           | 2.9 kB  00:00:00     
updates                                                                                             | 3.4 kB  00:00:00     
Loading mirror speeds from cached hostfile
 * base: mirror.pregi.net
 * epel: ftp.riken.jp
 * extras: mirror.pregi.net
 * remi-php72: mirrors.thzhost.com
 * remi-safe: mirrors.thzhost.com
 * updates: mirror.pregi.net
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.10-2.el7 will be installed
--> Processing Dependency: php-gd >= 5.3.7 for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-mbstring >= 5.3.7 for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-simplexml for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-tcpdf for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-tcpdf-dejavu-sans-fonts for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-xmlwriter for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Processing Dependency: php-zip for package: phpMyAdmin-4.4.15.10-2.el7.noarch
--> Running transaction check
---> Package php-gd.x86_64 0:7.2.4-1.el7.remi will be installed
--> Processing Dependency: gd-last(x86-64) >= 2.1.1 for package: php-gd-7.2.4-1.el7.remi.x86_64
--> Processing Dependency: libgd.so.3()(64bit) for package: php-gd-7.2.4-1.el7.remi.x86_64
---> Package php-mbstring.x86_64 0:7.2.4-1.el7.remi will be installed
---> Package php-pecl-zip.x86_64 0:1.15.2-1.el7.remi.7.2 will be installed
--> Processing Dependency: libzip5(x86-64) >= 1.3.2 for package: php-pecl-zip-1.15.2-1.el7.remi.7.2.x86_64
--> Processing Dependency: libzip.so.5()(64bit) for package: php-pecl-zip-1.15.2-1.el7.remi.7.2.x86_64
---> Package php-php-gettext.noarch 0:1.0.12-1.el7 will be installed
---> Package php-tcpdf.noarch 0:6.2.13-1.el7 will be installed
--> Processing Dependency: php-bcmath for package: php-tcpdf-6.2.13-1.el7.noarch
--> Processing Dependency: php-composer(fedora/autoloader) for package: php-tcpdf-6.2.13-1.el7.noarch
--> Processing Dependency: php-posix for package: php-tcpdf-6.2.13-1.el7.noarch
--> Processing Dependency: php-tidy for package: php-tcpdf-6.2.13-1.el7.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.13-1.el7 will be installed
---> Package php-xml.x86_64 0:7.2.4-1.el7.remi will be installed
--> Running transaction check
---> Package gd-last.x86_64 0:2.2.5-2.el7.remi will be installed
---> Package libzip5.x86_64 0:1.5.1-1.el7.remi will be installed
---> Package php-bcmath.x86_64 0:7.2.4-1.el7.remi will be installed
---> Package php-fedora-autoloader.noarch 0:1.0.0-1.el7 will be installed
---> Package php-process.x86_64 0:7.2.4-1.el7.remi will be installed
---> Package php-tidy.x86_64 0:7.2.4-1.el7.remi will be installed
--> Processing Dependency: libtidy.so.5()(64bit) for package: php-tidy-7.2.4-1.el7.remi.x86_64
--> Running transaction check
---> Package libtidy.x86_64 0:5.4.0-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================
 Package                                 Arch               Version                           Repository              Size
===========================================================================================================================
Installing:
 phpMyAdmin                              noarch             4.4.15.10-2.el7                   epel                   4.7 M
Installing for dependencies:
 gd-last                                 x86_64             2.2.5-2.el7.remi                  remi-safe              133 k
 libtidy                                 x86_64             5.4.0-1.el7                       epel                   174 k
 libzip5                                 x86_64             1.5.1-1.el7.remi                  remi-safe               55 k
 php-bcmath                              x86_64             7.2.4-1.el7.remi                  remi-php72              68 k
 php-fedora-autoloader                   noarch             1.0.0-1.el7                       epel                   9.6 k
 php-gd                                  x86_64             7.2.4-1.el7.remi                  remi-php72              75 k
 php-mbstring                            x86_64             7.2.4-1.el7.remi                  remi-php72             620 k
 php-pecl-zip                            x86_64             1.15.2-1.el7.remi.7.2             remi-php72              50 k
 php-php-gettext                         noarch             1.0.12-1.el7                      epel                    23 k
 php-process                             x86_64             7.2.4-1.el7.remi                  remi-php72              77 k
 php-tcpdf                               noarch             6.2.13-1.el7                      epel                   2.1 M
 php-tcpdf-dejavu-sans-fonts             noarch             6.2.13-1.el7                      epel                   257 k
 php-tidy                                x86_64             7.2.4-1.el7.remi                  remi-php72              61 k
 php-xml                                 x86_64             7.2.4-1.el7.remi                  remi-php72             203 k

Transaction Summary
===========================================================================================================================
Install  1 Package (+14 Dependent packages)

Total download size: 8.5 M
Installed size: 42 M
Is this ok [y/d/N]: y
Downloading packages:
(1/15): php-fedora-autoloader-1.0.0-1.el7.noarch.rpm                                                | 9.6 kB  00:00:00     
(2/15): libtidy-5.4.0-1.el7.x86_64.rpm                                                              | 174 kB  00:00:00     
(3/15): libzip5-1.5.1-1.el7.remi.x86_64.rpm                                                         |  55 kB  00:00:00     
(4/15): php-bcmath-7.2.4-1.el7.remi.x86_64.rpm                                                      |  68 kB  00:00:00     
(5/15): php-php-gettext-1.0.12-1.el7.noarch.rpm                                                     |  23 kB  00:00:00     
(6/15): php-gd-7.2.4-1.el7.remi.x86_64.rpm                                                          |  75 kB  00:00:00     
(7/15): gd-last-2.2.5-2.el7.remi.x86_64.rpm                                                         | 133 kB  00:00:01     
(8/15): php-process-7.2.4-1.el7.remi.x86_64.rpm                                                     |  77 kB  00:00:00     
(9/15): php-tcpdf-6.2.13-1.el7.noarch.rpm                                                           | 2.1 MB  00:00:00     
(10/15): php-tidy-7.2.4-1.el7.remi.x86_64.rpm                                                       |  61 kB  00:00:00     
(11/15): php-pecl-zip-1.15.2-1.el7.remi.7.2.x86_64.rpm                                              |  50 kB  00:00:01     
(12/15): php-xml-7.2.4-1.el7.remi.x86_64.rpm                                                        | 203 kB  00:00:01     
(13/15): phpMyAdmin-4.4.15.10-2.el7.noarch.rpm                                                      | 4.7 MB  00:00:01     
(14/15): php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch.rpm                                        | 257 kB  00:00:02     
(15/15): php-mbstring-7.2.4-1.el7.remi.x86_64.rpm                                                   | 620 kB  00:00:03     
---------------------------------------------------------------------------------------------------------------------------
Total                                                                                      1.9 MB/s | 8.5 MB  00:00:04     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : php-mbstring-7.2.4-1.el7.remi.x86_64                                                                   1/15 
  Installing : php-xml-7.2.4-1.el7.remi.x86_64                                                                        2/15 
  Installing : php-php-gettext-1.0.12-1.el7.noarch                                                                    3/15 
  Installing : libtidy-5.4.0-1.el7.x86_64                                                                             4/15 
  Installing : php-tidy-7.2.4-1.el7.remi.x86_64                                                                       5/15 
  Installing : php-process-7.2.4-1.el7.remi.x86_64                                                                    6/15 
  Installing : gd-last-2.2.5-2.el7.remi.x86_64                                                                        7/15 
  Installing : php-gd-7.2.4-1.el7.remi.x86_64                                                                         8/15 
  Installing : libzip5-1.5.1-1.el7.remi.x86_64                                                                        9/15 
  Installing : php-pecl-zip-1.15.2-1.el7.remi.7.2.x86_64                                                             10/15 
  Installing : php-fedora-autoloader-1.0.0-1.el7.noarch                                                              11/15 
  Installing : php-bcmath-7.2.4-1.el7.remi.x86_64                                                                    12/15 
  Installing : php-tcpdf-6.2.13-1.el7.noarch                                                                         13/15 
  Installing : php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch                                                       14/15 
  Installing : phpMyAdmin-4.4.15.10-2.el7.noarch                                                                     15/15 
  Verifying  : php-tcpdf-6.2.13-1.el7.noarch                                                                          1/15 
  Verifying  : php-xml-7.2.4-1.el7.remi.x86_64                                                                        2/15 
  Verifying  : php-bcmath-7.2.4-1.el7.remi.x86_64                                                                     3/15 
  Verifying  : phpMyAdmin-4.4.15.10-2.el7.noarch                                                                      4/15 
  Verifying  : php-pecl-zip-1.15.2-1.el7.remi.7.2.x86_64                                                              5/15 
  Verifying  : php-gd-7.2.4-1.el7.remi.x86_64                                                                         6/15 
  Verifying  : php-tidy-7.2.4-1.el7.remi.x86_64                                                                       7/15 
  Verifying  : php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch                                                        8/15 
  Verifying  : php-fedora-autoloader-1.0.0-1.el7.noarch                                                               9/15 
  Verifying  : php-mbstring-7.2.4-1.el7.remi.x86_64                                                                  10/15 
  Verifying  : libzip5-1.5.1-1.el7.remi.x86_64                                                                       11/15 
  Verifying  : gd-last-2.2.5-2.el7.remi.x86_64                                                                       12/15 
  Verifying  : php-process-7.2.4-1.el7.remi.x86_64                                                                   13/15 
  Verifying  : php-php-gettext-1.0.12-1.el7.noarch                                                                   14/15 
  Verifying  : libtidy-5.4.0-1.el7.x86_64                                                                            15/15 

Installed:
  phpMyAdmin.noarch 0:4.4.15.10-2.el7                                                                                      

Dependency Installed:
  gd-last.x86_64 0:2.2.5-2.el7.remi                        libtidy.x86_64 0:5.4.0-1.el7                                   
  libzip5.x86_64 0:1.5.1-1.el7.remi                        php-bcmath.x86_64 0:7.2.4-1.el7.remi                           
  php-fedora-autoloader.noarch 0:1.0.0-1.el7               php-gd.x86_64 0:7.2.4-1.el7.remi                               
  php-mbstring.x86_64 0:7.2.4-1.el7.remi                   php-pecl-zip.x86_64 0:1.15.2-1.el7.remi.7.2                    
  php-php-gettext.noarch 0:1.0.12-1.el7                    php-process.x86_64 0:7.2.4-1.el7.remi                          
  php-tcpdf.noarch 0:6.2.13-1.el7                          php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.13-1.el7              
  php-tidy.x86_64 0:7.2.4-1.el7.remi                       php-xml.x86_64 0:7.2.4-1.el7.remi                              

Complete!
[root@phpmyadmin ~]# 

修改 Apache 的配置

放开连接限制

代码语言:javascript
复制
[root@phpmyadmin ~]# rpm -ql  phpMyAdmin.noarch | grep etc
/etc/httpd/conf.d/phpMyAdmin.conf
/etc/phpMyAdmin
/etc/phpMyAdmin/config.inc.php
[root@phpmyadmin ~]# vim /etc/httpd/conf.d/phpMyAdmin.conf 
[root@phpmyadmin ~]# head -n 20 /etc/httpd/conf.d/phpMyAdmin.conf
# phpMyAdmin - Web based MySQL browser written in php
# 
# Allows only localhost by default
#
# But allowing phpMyAdmin to anyone other than localhost should be considered
# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
#     <RequireAny>
#       Require ip 127.0.0.1
#       Require ip ::1
#     </RequireAny>
     Require all granted
[root@phpmyadmin ~]# 
[root@phpmyadmin ~]# grep -v "#" /etc/httpd/conf.d/phpMyAdmin.conf

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     Require all granted
   </IfModule>
   <IfModule !mod_authz_core.c>
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/libraries/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/lib/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

<Directory /usr/share/phpMyAdmin/setup/frames/>
    Order Deny,Allow
    Deny from All
    Allow from None
</Directory>

[root@phpmyadmin ~]# 

修改 php 的配置

代码语言:javascript
复制
[root@phpmyadmin ~]# vim /etc/phpMyAdmin/config.inc.php
[root@phpmyadmin ~]# grep '^\$' /etc/phpMyAdmin/config.inc.php
$cfg['blowfish_secret'] = 'cuMQvacGFKf4aAjlebR1STNfJNgCreot'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$i = 0;
$i++;
$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysqli';    // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
$cfg['Servers'][$i]['auth_type']     = 'http';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = '';          // MySQL user
$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
$cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
$cfg['Servers'][$i]['hide_db']       = '';          // Database name to be hidden from listings
$cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
$cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
$cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
$cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
$cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
$cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
$cfg['Servers'][$i]['column_info']   = '';          // table to store column information
$cfg['Servers'][$i]['history']       = '';          // table to store SQL history
$cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
$cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
$cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
$cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
$cfg['Servers'][$i]['AllowNoPassword']              // Allow logins without a password. Do not change the FALSE
$cfg['Servers'][$i]['designer_coords']              // Leave blank (default) for no Designer support, otherwise
$cfg['Servers'][$i]['bs_garbage_threshold']         // Blobstreaming: Recommented default value from upstream
$cfg['Servers'][$i]['bs_repository_threshold']      // Blobstreaming: Recommented default value from upstream
$cfg['Servers'][$i]['bs_temp_blob_timeout']         // Blobstreaming: Recommented default value from upstream
$cfg['Servers'][$i]['bs_temp_log_threshold']        // Blobstreaming: Recommented default value from upstream
$cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
$cfg['SaveDir']   = '/var/lib/phpMyAdmin/save';
$cfg['PmaNoRelation_DisableWarning'] = TRUE;
[root@phpmyadmin ~]# 

进行访问

登录 http://192.168.56.213/phpmyadmin

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 前言
  • 操作
    • OS 环境
      • 软件环境
        • 安装软件包
          • 修改 Apache 的配置
            • 修改 php 的配置
              • 进行访问
              相关产品与服务
              云数据库 MySQL
              腾讯云数据库 MySQL(TencentDB for MySQL)为用户提供安全可靠,性能卓越、易于维护的企业级云数据库服务。其具备6大企业级特性,包括企业级定制内核、企业级高可用、企业级高可靠、企业级安全、企业级扩展以及企业级智能运维。通过使用腾讯云数据库 MySQL,可实现分钟级别的数据库部署、弹性扩展以及全自动化的运维管理,不仅经济实惠,而且稳定可靠,易于运维。
              领券
              问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档