MyWebSql 是一个基于Web的MySQL/Postgres数据库管理客户端,除了操作表格数据外,还可以对包括视图,存储过程,触发器和函数在内的对象进行控制。支持数据和查询结果的导入导出,还内置一个带语法着色功能的SQL编辑器。
快速,直观,开发人员友好的用户界面。
兼容所有主要的网络浏览器。
创建/编辑表结构,无需编写查询。
WYSIWYG编辑数据库表和查询数据。
同时编辑和删除多个记录极其轻松。
语法突出显示富文本sql编辑器内部的浏览器,无需任何插件。
将完整的数据库/表/查询结果导出到外部文件。
在不学习单个命令的情况下使用MySQL相关工具。
顺滑的界面,支持多种主题。
在几乎所有主要服务器配置上易于部署和安装。
[root@node config]# systemctl status docker |grep active Active: active (running) since Fri 2022-10-14 14:06:47 CST; 5h 7min ago
[root@node config]# docker-compose version docker-compose version 1.25.0, build 0a186604 docker-py version: 4.1.0 CPython version: 3.7.4 OpenSSL version: OpenSSL 1.1.0l 10 Sep 2019
[root@node mywebsql]# docker pull rizo928/mywebsql-flex Using default tag: latest latest: Pulling from rizo928/mywebsql-flex 7dcf5a444392: Pull complete 759aa75f3cee: Pull complete 3fa871dc8a2b: Pull complete 224c42ae46e7: Pull complete 9e4d7c038c3d: Pull complete 2bef889cbb8f: Pull complete be57bc4687e5: Pull complete 60c801568b81: Pull complete 8c2e7907f75b: Pull complete 0b1b15dd6a1b: Pull complete 23d29f4252f8: Pull complete d687c5477ed5: Pull complete 2941b08edd24: Pull complete 3b4a514b0015: Pull complete 9bafa9902ec3: Pull complete Digest: sha256:3debe666e4b65c116e2814ae070b54079654ca561745491d51138230ca21c673 Status: Downloaded newer image for rizo928/mywebsql-flex:latest docker.io/rizo928/mywebsql-flex:latest
[root@node mywebsql]# cat docker-compose.yaml version: '3.0' services: db: image: mariadb:10.5 container_name: mywebsql-db restart: always environment: - MYSQL_ROOT_PASSWORD=mindoc - MYSQL_DATABASE=mindoc - MYSQL_USER=mindoc - MYSQL_PASSWORD=mindoc volumes: - /data/mindoc/db:/var/lib/mysql # Requested, specifies the path to MySQL data persistent store. networks: - mywebsql ports: - 3422:3306 webmysql: image: rizo928/mywebsql-flex container_name: mywebsql restart: always volumes: - /data/mywebsql/config:/config ports: - 9088:80 depends_on: - db networks: - mywebsql networks: mywebsql:
[root@node mywebsql]# docker-compose up -d Creating network "mywebsql_mywebsql" with the default driver Creating mywebsql-db ... done Creating mywebsql ... done
[root@node mywebsql]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 0fb0ebac00d6 mysql:5.7 "docker-entrypoint.s…" About an hour ago Up About an hour 0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp some-mysql 3fa0565b18d8 rizo928/mywebsql-flex "/sbin/my_init" 2 hours ago Up 37 minutes 0.0.0.0:9088->80/tcp, :::9088->80/tcp mywebsql 3f49db3d5264 mariadb:10.5 "docker-entrypoint.s…" 2 hours ago Up 2 hours 0.0.0.0:3422->3306/tcp, :::3422->3306/tcp mywebsql-db
[root@node mywebsql]# docker logs mywebsql Starting pre-service scritps in /etc/my_init.d *** Running: /etc/my_init.d/startup.sh mywebsql installed... config directory exists /config is Empty starting rc.local scritps *** Running: /etc/rc.local Booting runit daemon... Process runsvdir running with PID 222 Begin shutting down runit services... Starting pre-service scritps in /etc/my_init.d *** Running: /etc/my_init.d/startup.sh mywebsql installed... config directory exists we are already configured *** Running: /etc/rc.local starting rc.local scritps Booting runit daemon... Process runsvdir running with PID 236 Begin shutting down runit services... Starting pre-service scritps in /etc/my_init.d *** Running: /etc/my_init.d/startup.sh mywebsql installed... config directory exists we are already configured *** Running: /etc/rc.local starting rc.local scritps Booting runit daemon... Process runsvdir running with PID 236 httpd (pid 245) already running Begin shutting down runit services... Starting pre-service scritps in /etc/my_init.d *** Running: /etc/my_init.d/startup.sh mywebsql installed... config directory exists we are already configured *** Running: /etc/rc.local starting rc.local scritps Booting runit daemon... Process runsvdir running with PID 236 Begin shutting down runit services... Starting pre-service scritps in /etc/my_init.d *** Running: /etc/my_init.d/startup.sh mywebsql installed... config directory exists we are already configured *** Running: /etc/rc.local starting rc.local scritps Booting runit daemon... Process runsvdir running with PID 236 httpd (pid 245) already running
[root@server ~]# docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES e3a109b3ac77 pingcap/tispark:v2.1.1 "/opt/spark/sbin/sta…" 3 days ago Up 4 minutes 0.0.0.0:38081->38081/tcp, :::38081->38081/tcp tidb-docker-compose-master_tispark-slave0_1 750f938b9669 pingcap/tispark:v2.1.1 "/opt/spark/sbin/sta…" 3 days ago Up 4 minutes 0.0.0.0:7077->7077/tcp, :::7077->7077/tcp, 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp tidb-docker-compose-master_tispark-master_1 7fd728cc1019 pingcap/tidb:latest "/tidb-server --stor…" 3 days ago Up 7 seconds 0.0.0.0:4000->4000/tcp, :::4000->4000/tcp, 0.0.0.0:10080->10080/tcp, :::10080->10080/tcp tidb-docker-compose-master_tidb_1 0e18dbcd2efe pingcap/tikv:latest "/tikv-server --addr…" 3 days ago Up 20 seconds 20160/tcp tidb-docker-compose-master_tikv0_1 3789709f53b1 pingcap/tikv:latest "/tikv-server --addr…" 3 days ago Up 4 minutes 20160/tcp tidb-docker-compose-master_tikv2_1 304c90121b1c pingcap/tikv:latest "/tikv-server --addr…" 3 days ago Up 4 minutes 20160/tcp tidb-docker-compose-master_tikv1_1 d3f461f3e313 pingcap/pd:latest "/pd-server --name=p…" 3 days ago Up 19 seconds 2380/tcp, 0.0.0.0:49154->2379/tcp, :::49154->2379/tcp tidb-docker-compose-master_pd1_1 6b2a18f4b823 prom/pushgateway:v0.3.1 "/bin/pushgateway --…" 3 days ago Up 19 seconds 9091/tcp tidb-docker-compose-master_pushgateway_1 51deb002f753 grafana/grafana:6.0.1 "/run.sh" 3 days ago Up 18 seconds 0.0.0.0:3000->3000/tcp, :::3000->3000/tcp tidb-docker-compose-master_grafana_1 82b528f74a0c pingcap/pd:latest "/pd-server --name=p…" 3 days ago Up 4 minutes 2380/tcp, 0.0.0.0:49153->2379/tcp, :::49153->2379/tcp tidb-docker-compose-master_pd2_1 0939bfabe52b prom/prometheus:v2.2.1 "/bin/prometheus --l…" 3 days ago Up 17 seconds 0.0.0.0:9090->9090/tcp, :::9090->9090/tcp tidb-docker-compose-master_prometheus_1 b2d645e3b30a pingcap/tidb-vision:latest "/bin/sh -c 'sed -i …" 3 days ago Up 4 minutes 80/tcp, 443/tcp, 2015/tcp, 0.0.0.0:8010->8010/tcp, :::8010->8010/tcp tidb-docker-compose-master_tidb-vision_1 c3cb9f6acc84 pingcap/pd:latest "/pd-server --name=p…" 3 days ago Up 14 seconds 2380/tcp, 0.0.0.0:49155->2379/tcp, :::49155->2379/tcp tidb-docker-compose-master_pd0_1
[root@server ~]# mysql -h 127.0.0.1 -P 4000 -u root
如果您发现该资源为电子书等存在侵权的资源或对该资源描述不正确等,可点击“私信”按钮向作者进行反馈;如作者无回复可进行平台仲裁,我们会在第一时间进行处理!
加入交流群
请使用微信扫一扫!