Chunk #501
Aus: Installation (Index: 3)
201
Tokens
Synced
Status
Taxonomie
| Kategorie | Installation |
|---|---|
| Pfad | Installation > MCP-DB Installation > Datenbank vorbereiten |
| Heading-Pfad | Installation > MCP-DB Installation > 5. Datenbank vorbereiten > DB-User erstellen |
Entities
| Name | Typ |
|---|---|
| mcp_readonly | TECHNOLOGY |
| mcp_logger | TECHNOLOGY |
| ki_protokoll | DATABASE |
| SELECT | COMMAND |
| GRANT | COMMAND |
| FLUSH PRIVILEGES | COMMAND |
Keywords
Inhalt
-- mcp_readonly
CREATE USER IF NOT EXISTS 'mcp_readonly'@'localhost'
IDENTIFIED BY 'SECURE_PASSWORD_HERE';
GRANT SELECT ON ki_protokoll.mcp_log TO 'mcp_readonly'@'localhost';
GRANT SELECT ON ki_protokoll.ki_eintraege TO 'mcp_readonly'@'localhost';
GRANT SELECT ON ki_protokoll.ki_kategorien TO 'mcp_readonly'@'localhost';
GRANT SELECT ON ki_protokoll.ki_tags TO 'mcp_readonly'@'localhost';
GRANT SELECT ON ki_protokoll.ki_settings TO 'mcp_readonly'@'localhost';
GRANT SELECT ON information_schema.TABLES TO 'mcp_readonly'@'localhost';
GRANT SELECT ON ki_system.* TO 'mcp_readonly'@'localhost';
-- mcp_logger
CREATE USER IF NOT EXISTS 'mcp_logger'@'localhost'
IDENTIFIED BY 'DIFFERENT_SECURE_PASSWORD_HERE';
GRANT INSERT ON ki_protokoll.mcp_log TO 'mcp_logger'@'localhost';
FLUSH PRIVILEGES;Clean Content
``` `-- mcp_readonly CREATE USER IF NOT EXISTS 'mcp_readonly'@'localhost' IDENTIFIED BY 'SECURE_PASSWORD_HERE'; GRANT SELECT ON ki_protokoll.mcp_log TO 'mcp_readonly'@'localhost'; GRANT SELECT ON ki_protokoll.ki_eintraege TO 'mcp_readonly'@'localhost'; GRANT SELECT ON ki_protokoll.ki_kategorien TO 'mcp_readonly'@'localhost'; GRANT SELECT ON ki_protokoll.ki_tags TO 'mcp_readonly'@'localhost'; GRANT SELECT ON ki_protokoll.ki_settings TO 'mcp_readonly'@'localhost'; GRANT SELECT ON information_schema.TABLES TO 'mcp_readonly'@'localhost'; GRANT SELECT ON ki_system.* TO 'mcp_readonly'@'localhost'; -- mcp_logger CREATE USER IF NOT EXISTS 'mcp_logger'@'localhost' IDENTIFIED BY 'DIFFERENT_SECURE_PASSWORD_HERE'; GRANT INSERT ON ki_protokoll.mcp_log TO 'mcp_logger'@'localhost'; FLUSH PRIVILEGES;` ```
Metadaten
| Analysiert am | 20.12.2025 12:41:23 |
|---|---|
| Analyse-Modell | gemma3:4b-it-qat |
| Embedding-Modell | mxbai-embed-large |
| Qdrant-ID | c9686698-3903-47ee-bc5a-4465997338f7 |
| Erstellt | 20.12.2025 12:34:42 |
| Aktualisiert | 20.12.2025 12:53:38 |