当前位置: 首页 > 后端技术 > Java

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

时间:2023-04-01 13:35:51 Java

后台管理数据库接口工具。开发团队一般都有非技术背景的人员,比如:产品和功能测试人员;对于他们来说,安装数据库管理工具客户端可能比较麻烦,需要一个在线的web工具来方便自己查看数据。本地docker安装单库:dockerrun--namemyadmin-d-ePMA_HOST=lifcHost-ePMA_PORT=3306-ePMA_USER=root-ePMA_PASSWORD=Root1234-p9001:80phpmyadmin多库: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_hostsas$key=>$sh){$cfg['Servers'][$key]['v??erbose']=$sh['server_name'];$cfg['服务器'][$key]['auth_type']='cookie';$cfg['服务器'][$key]['主机']=$sh['主机'];$cfg['服务器'][$key]['用户']=$sh['用户'];$cfg['服务器'][$key]['端口']=$sh['端口'];$cfg['服务器'][$key]['密码']=$sh['pa剑'];$cfg['服务器'][$key]['connect_type']='tcp';$cfg['服务器'][$key]['压缩']=false;$cfg['服务器'][$key]['扩展']='mysqli';$cfg['Servers'][$key]['AllowNoPassword']=false;}$cfg['ServerDefault']=1;dockerrun--namemyadmin-p9001:80-vd:/test/phpMyAdmin/config/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php-dphpmyadmin主页需要服务器的账号和密码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_hostsas$key=>$sh){$cfg['Servers'][$key]['v??erbose']=$sh['server_name'];$cfg['服务器'][$key]['auth_type']='cookie';$cfg['服务器'][$key]['主机']=$sh['主机'];$cfg['服务器'][$key]['用户']=$sh['用户'];$cfg['服务器'][$key]['端口']=$sh['端口'];$cfg['服务器'][$key]['密码']=$sh['密码'];$cfg['服务器'][$key]['connect_type']='tcp';$cfg['服务器'][$key]['压缩']=false;$cfg['Servers'][$key]['extension']='mysqli';$cfg['Servers'][$key]['AllowNoPassword']=false;}$cfg['ServerDefault']=1;---apiVersion:apps/v1kind:Deploymentmetadata:name:phpmyadminnamespace:tplabels:cycube:phpmyadminspec:replicas:1revisionHistoryLimit:10selector:matchLabels:cycube:phpmyadmintemplate:metadata:标签:cycube:phpmyadmin规范:restartPolicy:AlwaysschedulerName:默认调度程序dnsPolicy:ClusterFirstterminationGracePeriodSeconds:120imagePullSecrets:-名称:ali-sh2-cycube-images容器:-图像:phpmyadmin名称:phpmyadminimagePullPolicy:IfNotPresentvolumeMounts:-名称:phpmyadmin-volumemountPath:/etc/phpmyadmin/config.user.inc.php子路径:config.user.inc.php资源:限制:cpu:250m内存:512Mi请求:cpu:125m内存:256Mi端口:-名称:httpcontainerPort:80协议:TCPlivenessProbe:httpGet:path:/port:80scheme:HTTPinitialDelaySeconds:120periodSeconds:30readinessProbe:httpGet:path:/port:80scheme:HTTPinitialDelaySeconds:90timeoutSeconds:15periodSeconds:30successThreshold:1failureThreshold:5volumes:-name:phpmyadmin-volumeconfigMap:name:configmap-phpmyadminitems:-key:config.user.inc.phppath:config.user.inc.php---apiVersion:v1kind:Servicemetadata:name:svc-phpmyadmin-nspec:ports:-name:phpmyadmin-port端口:80协议:TCPtargetPort:80nodePort:30401selector:cycube:phpmyadminsessionAffinity:Nonetype:NodePort执行命令:kubectlapply-fphpadmin.yml-ntp进入:概要一个统一的数据库管理工具,替代客户端。网络版更酷。原创不易,关注可贵,转发价更高!转载请注明出处,让我们互相交流,共同进步。欢迎交流。