MariaDb won’t start debian 9

debian-stretchmariadb

I just tried to make some changes in my.cnf like: innodb_buffer_pool_size, innodb_log_file_size, innodb_flush_log_at_trx_commit=0, and add "skip-name-resolve"
and from that time, can't start the mariadb, even I have reverse all changes still won't work ….

I'm desperate because my shop not working, clear all of the mysql, install new, still do not start…

when i try to start or install get this errors:

Jun 27 12:28:36 server systemd[4311]: mariadb.service: Failed to change ownership of session keyring: Permission denied
Jun 27 12:28:36 server systemd[4311]: mariadb.service: Failed to set up kernel keyring: Permission denied
Jun 27 12:28:36 server systemd[4311]: mariadb.service: Failed at step KEYRING spawning /usr/bin/install: Permission denied
-- Subject: Process /usr/bin/install could not be executed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The process /usr/bin/install could not be executed and failed.
--
-- The error number returned by this process is 13.
Jun 27 12:28:36 server systemd[1]: mariadb.service: Control process exited, code=exited status=237
Jun 27 12:28:36 server systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 27 12:28:36 server systemd[1]: Failed to start MariaDB 10.1.33 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.

somebody can help me ? really don't know what to do….

tried to executed /usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld, and start in safe mode… but still doesn't work

Best Answer

final edit: This has been reported as bug no 865870, try upgrading your packages.

apt-get update && apt-get upgrade