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 

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

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 

即可进入：

小结

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

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