node-mysql-audit

library1.4.1jsnpmunverified

This package (v1.4.1) automatically tracks and logs MySQL database changes using triggers and events. It generates a configuration file upon installation and provides functions to initialize connections and set up auditing for specified tables. Suitable for Node.js environments with MySQL databases. Designed for audit compliance and change tracking. Released as a stable version with active updates. Differentiates by providing a non-invasive auditing mechanism.

database security

npm install node-mysql-audit

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · NODE-MYSQL-AUDIT

node-mysql-audit

databasejavascriptv1.4.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

initConnection

✓ import { initConnection } from 'node-mysql-audit'

✗ const initConnection = require('node-mysql-audit').initConnection

ESM-only package; use import syntax

setupDatabaseAudit

✓ import { setupDatabaseAudit } from 'node-mysql-audit'

✗ const { setupDatabaseAudit } = require('node-mysql-audit')

ESM-only; named import required

default import

✓ import * as Audit from 'node-mysql-audit'

✗ import Audit from 'node-mysql-audit'

No default export; use namespace import

Initialize MySQL connection and set up database auditing with user credentials.

import { initConnection, setupDatabaseAudit } from 'node-mysql-audit'; // Initialize connection using config generated during install initConnection(); // Set up audit for user ID 1 and username 'admin' setupDatabaseAudit(1, 'admin'); console.log('Database audit configured successfully.');

Debug

Known issues

gotchaConfiguration file is auto-generated on install; must be edited before calling initConnection

fix

Edit the generated configuration file (likely audit-config.json) to set database credentials.

affects: *

gotchaThe package uses MySQL triggers and events which require sufficient database privileges

fix

Ensure the database user has CREATE TRIGGER, CREATE EVENT, and SELECT/INSERT/UPDATE permissions on the audit tables.

affects: *

breakingNo connection parameter in initConnection(); uses config file only

fix

Set database credentials in the config file before calling initConnection().

affects: >=1.0.0

Errors

Common errors & fixes

Error: Cannot find module 'node-mysql-audit'

Package not installed or import path incorrect

fix

Run npm install node-mysql-audit

TypeError: initConnection is not a function

Using default import instead of named import

fix

Use import { initConnection } from 'node-mysql-audit'

Error: ER_ACCESS_DENIED_ERROR: Access denied for user

Incorrect database credentials in config file

fix

Update the configuration file with correct database host, user, password, and database name.

Upgrade

Version history

1.4.1latest on npm

Audit

Dependencies

mysql2optionalProvides MySQL database connection

Agent activity

17 hits · last 30 days

node

Resources

githubhttps://github.com/raniaby/node-mysql-audit ↗

packagenode-mysql-audit ↗

homepagehttps://github.com/raniaby/node-mysql-audit ↗