Running Linux Mint 22.3
trying to install (I have my old logs)
I've been following this thread:
https://www.cqrlog.com/node/6159
and I get to #4
mariadb - access denied
Do I have to try and access using root?
Jerry
KI4IO
Thu, 2026-09-10 01:02
#1
CQRLOG failure due to database connection
HI Jerry!
mariadb - access denied means you do not have database user access ok.
At "Database connect" window if you use "Save log data to local machine" you do not need to worry about database user or connection settings.
But if you want to use external MariaDB server that can be in same PC running at port 3306 or exist elsewhere in local network or internet you need to have database username with password and privileges to use that database server.
Database username and password are separate than you Linux username and password.
You should not use root account for anything else than creating a database user before running Cqrlog in case you want to use external SQL server.
Have you checked this message ? https://www.cqrlog.com/comment/11126#comment-11126
--
Saku
OH1KH
I do use "save log data to a local machine".
Prior to getting that window, I get:
MySQL server connect failed
and
MySQL could not be started, please check if the MySQL server is installed properly
also
I do not want a fresh start - I'd like to have CQRLOG running with all my old logs.
Jerry
Ok Jerry.
I assume you have then upgraded your Mint.
First you could try to find files called ib_logfileX where X can be any number. They exist in ~/.config/cqrlog/database
They are safe to remove and may help in some cases.
How ever make backup first from folder ~/.config/cqrlog
If that does not help you could try to download script from my github
https://github.com/OH1KH/CqrlogImproved/blob/devel/tools/new-cqrlog-appa...
Run that with sudo and it should add a new line to etc/apparmor file that is needed with new (u)buntu variants to allow MariaDB run in user's folder.
See: https://www.cqrlog.com/node/6161
If that doesn't help and you have fresh backup from ~/.config/cqrlog you could delete the folder from computer and try fresh start of cqrlog.
If you can create first empty log by that it confirms that your MariaDB installation works and the problem is in the old folder data that may be written with pevious version of MariaDB.
On the other hand if you can not create first empty log it shows that you have problem with MariaDB installation and need to fix it and when that is working restore your old ~/.config/cqrlog and try again.
--
Saku
OH1KH