ubuntu安装metabase

版本

ubuntu24

jdk21

mysql8

metabase v0.57.6

安装

创建mysql数据库：

在mysql中新建数据库：metabase

启动metabase:

export MB_DB_TYPE=mysql
export MB_DB_USER=metabase
export MB_DB_PASS=123456
export MB_DB_CONNECTION_URI="jdbc:mysql://192.168.1.183:3306/metabase?useSSL=false&allowPublicKeyRetrieval=true"
export MB_JETTY_PORT=3388
export JAVA_HOME=/home/phoenix/apps/jdk-21.0.9+10
/home/phoenix/apps/jdk-21.0.9+10/bin/java -Xms4g -Xmx6g -jar /home/phoenix/apps/metabase/metabase.jar

服务自启动：

cd /etc/systemd/system
sudo vim metabase.service

[Unit]
Description=metabase Server
After=network.target 

[Service]
Type=simple
User=phoenix
Group=phoenix
# 修改为你的 Metabase 安装目录
WorkingDirectory=/home/phoenix/apps/metabase
ExecStart=sh /home/phoenix/apps/metabase/startmetabase.sh

[Install]
WantedBy=multi-user.target

自启动：sudo systemctl enable metabase.service

启动：sudo systemctl start metabase.service