使用已有數(shù)據(jù)庫(kù)

創(chuàng)建本地?cái)?shù)據(jù)庫(kù)

數(shù)據(jù)庫(kù)：nocodb
用戶：nocodb
密碼：xxxxxx

修改docker-compose.yml

默認(rèn)網(wǎng)關(guān)的 IP 地址是 172.17.0.1（適用于 bridge 網(wǎng)絡(luò)模式）

version: "2.1"
services:nocodb:environment:# 更新數(shù)據(jù)庫(kù)連接信息為宿主機(jī)的 MySQLNC_DB: "mysql2://172.17.0.1:3306?u=nocodb&p=xxxxxx&d=nocodb"image: "nocodb/nocodb:latest"ports:- "28080:8080"restart: alwaysvolumes:- "/opt/ai-server/nocodb_data:/usr/app/data"
volumes:nc_data: {}

啟動(dòng)鏡像

docker compose up -d

查看日志

docker ps 
docker logs nocodb-nocodb-1 (根據(jù)上一步獲取的名稱來(lái)查看)

找到
[Nest] 9 - 12/27/2024, 8:02:03 AM ERROR [ExceptionHandler] Error: Access denied for user ‘nocodb’@‘172.25.0.2’ (using password: YES)

給用戶授權(quán)IP訪問(wèn)

mysql-5.7.14mysql -h 127.0.0.1 -P 3306 -u root -p xxxxxxxx
GRANT ALL PRIVILEGES ON nocodb.* TO 'nocodb'@'172.25.0.2';
FLUSH PRIVILEGES;

等待nocodb自動(dòng)重啟

訪問(wèn)

http://127.0.0.1:28080

使用獨(dú)立的docker中新的mysql

配置 docker-compose.yml

version: "2.1"
services: nocodb: depends_on: root_db: condition: service_healthyenvironment: NC_DB: "mysql2://root_db:3306?u=noco&p=password&d=root_db"image: "nocodb/nocodb:latest"ports: - "28080:8080"restart: alwaysvolumes: - "nc_data:/usr/app/data"root_db: environment: MYSQL_DATABASE: root_dbMYSQL_PASSWORD: passwordMYSQL_ROOT_PASSWORD: passwordMYSQL_USER: nocohealthcheck: retries: 10test: - CMD- mysqladmin- ping- "-h"- localhosttimeout: 20simage: "mysql:8.3.0"restart: alwaysvolumes: - "db_data:/var/lib/mysql"
volumes: db_data: {}nc_data: {}

注意修改一些敏感數(shù)據(jù)

啟動(dòng)

docker compose up -d

訪問(wèn)

http://127.0.0.1:28080