背景

管理数据库的界面工具。

开发团队中一般有非技术背景人员，比如： 产品，功能测试人员；

对他们来说，可能安装数据库管理工具客户端都很麻烦，需要一款在线的网页工具能方便他们查阅数据。

本地docker安装

单库：

docker run --name myadmin -d -e PMA_HOST=lifcHost  -e PMA_PORT=3306 -e PMA_USER=root -e PMA_PASSWORD=Root1234  -p 9001:80 phpmyadmin

多库：

php初始化文件：

<?php
$server_hosts = array(
	\'1\' => array(\'server_name\' => \'lifcHost\', \'host\' => \'lifcHost\', \'port\' => 3306, \'user\'=>\'root\', \'password\' => \'Root1234\'),
	\'2\' => array(\'server_name\' => \'dev\', \'host\' => \'10.10.1.23\', \'port\' => 30099,\'user\'=>\'root\', \'password\' => \'Cycube123!\'),
	\'3\' => array(\'server_name\' => \'uat\', \'host\' => \'10.10.1.23\', \'port\' => 30099,\'user\'=>\'root\', \'password\' => \'Cycube123!\')
);

foreach($server_hosts as $key => $sh)
{
	$cfg[\'Servers\'][$key][\'verbose\'] = $sh[\'server_name\'];
	$cfg[\'Servers\'][$key][\'auth_type\'] = \'cookie\';
	$cfg[\'Servers\'][$key][\'host\'] = $sh[\'host\'];
	$cfg[\'Servers\'][$key][\'user\'] = $sh[\'user\']; 
	$cfg[\'Servers\'][$key][\'port\'] = $sh[\'port\']; 
	$cfg[\'Servers\'][$key][\'password\'] = $sh[\'password\'];
	$cfg[\'Servers\'][$key][\'connect_type\'] = \'tcp\';
	$cfg[\'Servers\'][$key][\'compress\'] = false;
	$cfg[\'Servers\'][$key][\'extension\'] = \'mysqli\';
	$cfg[\'Servers\'][$key][\'AllowNoPassword\'] = false;
}
$cfg[\'ServerDefault\'] = 1;

docker run --name myadmin -p 9001:80  -v d:/test/phpMyAdmin/config/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php  -d phpmyadmin

首页需要收入服务器的账号和密码。

k8s安装

---
apiVersion: v1
kind: ConfigMap
metadata:
  name: configmap-phpmyadmin
data:
  config.user.inc.php: |-
    <?php
    $server_hosts = array(
    \'1\' => array(\'server_name\' => \'prod\', \'host\' => \'sh-cdb-l5xxx.com\', \'port\' => 59153, \'user\'=>\'cyxxxe_read\', \'password\' => \'xxxxx\'),
    \'2\' => array(\'server_name\' => \'dev\', \'host\' => \'10.10.1.23\', \'port\' => 30099,\'user\'=>\'root\', \'password\' => \'xxx123!\')
    );
    
    foreach($server_hosts as $key => $sh)
    {
      $cfg[\'Servers\'][$key][\'verbose\'] = $sh[\'server_name\'];
      $cfg[\'Servers\'][$key][\'auth_type\'] = \'cookie\';
      $cfg[\'Servers\'][$key][\'host\'] = $sh[\'host\'];
      $cfg[\'Servers\'][$key][\'user\'] = $sh[\'user\'];
      $cfg[\'Servers\'][$key][\'port\'] = $sh[\'port\'];
      $cfg[\'Servers\'][$key][\'password\'] = $sh[\'password\'];
      $cfg[\'Servers\'][$key][\'connect_type\'] = \'tcp\';
      $cfg[\'Servers\'][$key][\'compress\'] = false;
      $cfg[\'Servers\'][$key][\'extension\'] = \'mysqli\';
      $cfg[\'Servers\'][$key][\'AllowNoPassword\'] = false;
    }
    $cfg[\'ServerDefault\'] = 1;

---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: phpmyadmin
  namespace: tp
  labels:
    cycube: phpmyadmin
spec:
  replicas: 1
  revisionHistoryLimit: 10
  selector:
    matchLabels:
      cycube: phpmyadmin
  template:
    metadata:
      labels:
        cycube: phpmyadmin
    spec:
      restartPolicy: Always
      schedulerName: default-scheduler
      dnsPolicy: ClusterFirst
      terminationGracePeriodSeconds: 120
      imagePullSecrets:
        - name: ali-sh2-cycube-images
      containers:
        - image: phpmyadmin
          name: phpmyadmin
          imagePullPolicy: IfNotPresent
          volumeMounts:
            - name: phpmyadmin-volume
              mountPath: /etc/phpmyadmin/config.user.inc.php
              subPath: config.user.inc.php
          resources:
            limits:
              cpu: 250m
              memory: 512Mi
            requests:
              cpu: 125m
              memory: 256Mi
          ports:
            - name: http
              containerPort: 80
              protocol: TCP
          livenessProbe:
            httpGet:
              path: /
              port: 80
              scheme: HTTP
            initialDelaySeconds: 120
            periodSeconds: 30
          readinessProbe:
            httpGet:
              path: /
              port: 80
              scheme: HTTP
            initialDelaySeconds: 90
            timeoutSeconds: 15
            periodSeconds: 30
            successThreshold: 1
            failureThreshold: 5
      volumes:
        - name: phpmyadmin-volume
          configMap:
            name: configmap-phpmyadmin
            items:
              - key: config.user.inc.php
                path: config.user.inc.php


---
apiVersion: v1
kind: Service
metadata:
  name: svc-phpmyadmin-n
spec:
  ports:
    - name: phpmyadmin-port
      port: 80
      protocol: TCP
      targetPort: 80
      nodePort: 30401
  selector:
    cycube: phpmyadmin
  sessionAffinity: None
  type: NodePort

执行指令：

kubectl apply -f phpadmin.yml -n tp

即可进入：

小结

替代客户端的一个统一管理数据库的工具。 网页版本更清凉。

原创不易，关注诚可贵，转发价更高！转载请注明出处，让我们互通有无，共同进步，欢迎沟通交流。

no pays,no gains!

来源：https://www.cnblogs.com/snidget/p/16977003.html
本站部分图文来源于网络，如有侵权请联系删除。