背景
管理数据库的界面工具。
开发团队中一般有非技术背景人员，比如： 产品，功能测试人员；
对他们来说，可能安装数据库管理工具客户端都很麻烦，需要一款在线的网页工具能方便他们查阅数据。
本地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初始化文件：
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: v1kind: ConfigMapmetadata: name: configmap-phpmyadmindata: config.user.inc.php: |- 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/v1kind: Deploymentmetadata: name: phpmyadmin namespace: tp labels: cycube: phpmyadminspec: 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: v1kind: Servicemetadata: name: svc-phpmyadmin-nspec: 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!