DBAdmin/journals/2026-05-11.md

type, title, date, tags, Status

type	title	date	tags	Status
DailyNote	Daily Note - 2026-05-12	2026-05-12 08:06:11		Active

CREATE USER 'dnb_eu_dba'@'%' IDENTIFIED BY 'CommonDBA890!@#'; GRANT ALL PRIVILEGES ON * . * TO 'dnb_eu_dba'@'%' WITH GRANT OPTION; ALTER USER 'dnb_eu_dba'@'%' PASSWORD EXPIRE NEVER; FLUSH PRIVILEGES;

log-error=/var/log/mysql/error.log slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow-query.log long_query_time = 5 innodb_file_per_table = 1 #bind-address=10.198.1.136 bind-address=0.0.0.0 port=3306

CREATE USER 'dnb_eu_dba'@'%' IDENTIFIED BY 'CommonDBA890!@#'; GRANT ALL PRIVILEGES ON * . * TO 'dnb_eu_dba'@'%' WITH GRANT OPTION; ALTER USER 'dnb_eu_dba'@'%' PASSWORD EXPIRE NEVER; FLUSH PRIVILEGES;

CREATE USER 'splunk'@'localhost' IDENTIFIED BY 'xPOfVfLbKpv4kHu!@#78';

GRANT SELECT ON performance_schema.* TO 'splunk'@'localhost';

GRANT RELOAD, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'splunk'@'localhost';

ALTER USER 'splunk'@'localhost' PASSWORD EXPIRE NEVER;

FLUSH PRIVILEGES;

chmybccdb0npl01 root Cc-2ch019.$qsRa

GRANT SLAVE MONITOR ON . TO 'splunk'@'127.0.0.1';

FLUSH PRIVILEGES;

INC0805514 -> (Splunk Observability) Disk > 80% [G:] CHDBASQDB0NPW01.bisnodech.local - backup and truncate logs INC0805145 -> (Splunk Observability) Disk > 80% [/var/log] chmybccdb0npl01.blue.bisnode.net - Monitoring issue, repair splunk otel SCTASK0737627 -> General Database Request - BART DRN 3422 - preparation to migration - Full backup and restore ~1:10 + incremental backup ~20 min If is posibility to run backup and restore in one day