phpMyAdmin给非技术人员一个查阅数据库的窗口

phpMyAdmin给非技术人员一个查阅数据库的窗口

背景

管理数据库的界面工具。

开发团队中一般有非技术背景人员,比如: 产品,功能测试人员;

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

本地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

file

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

file

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

即可进入:

file

file

小结

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

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

hmoban主题是根据ripro二开的主题,极致后台体验,无插件,集成会员系统
自学咖网 » phpMyAdmin给非技术人员一个查阅数据库的窗口