I appreciate your help! Thanks for the Google links. One of them them revealed the solution:
https://stackoverflow.com/questions/2057...sqld-mysql
Edit mysql config file by doing the below: sudo nano /etc/mysql/my.cnf and add tc-heuristic-recover=rollback under [mysqld]
Try to start mysql/mariadb server by sudo systemctl start mysql.service and it should fail with this error Can't init tc log.
Don't worry, just edit the config file again and comment tc-heuristic-recover=rollback
Try to start the mysql server again with sudo service start mysql.service and it should work fine.
Check the status to confirm service status mysql.service
https://stackoverflow.com/questions/2057...sqld-mysql
Edit mysql config file by doing the below: sudo nano /etc/mysql/my.cnf and add tc-heuristic-recover=rollback under [mysqld]
Try to start mysql/mariadb server by sudo systemctl start mysql.service and it should fail with this error Can't init tc log.
Don't worry, just edit the config file again and comment tc-heuristic-recover=rollback
Try to start the mysql server again with sudo service start mysql.service and it should work fine.
Check the status to confirm service status mysql.service
