it says systemctl command not found
try
service mariadb status
i try it say
mariadb unrecognized service
replace mariadb with mysql instead,
it should be like this
service mysql status
which OS are you using?
MariaDB is stopped
i use Ubuntu 14.04
you can follow these instructions
it says you have to run two commands
first is
mysqld --tc-heuristic-recover=ROLLBACK
then restart mysql service by running
service mysql start
1 Like
try to start mysql after that by running
service mysql start
can you run the commands as root and see how it goes?
repeat both two commands
Can you show the output for
su [it will ask you for the root password]
tail -n 20 /var/log/mysql/error.log
tail -n 5 /home/frappe/frappe-bench/logs/*.log
1 Like
Authentication failure
i don’t know the root password.
here is the output of tail -n 5 /home/frappe/frappe-bench/logs/*.log
Here is the output of tail -n 20 /var/log/mysql/error.log
Do you at least have access to a sudo user?
yes i have sudo access
If that is the case, then you can use the sudo user to set/change the root password
sudo passwd root
then input the new passwords
i changed the root password and here is the output
It looks to me like your mariadb/mysqld installation was erroneous or incomplete.
The default location for data files is /var/lib/mysql and you can status/start/stop/restart it with
sudo /etc/init.d/mysql status
#OR
sudo service mysql status
While you’re checking your system, do you have enough disk space and free memory?
free -h
df -h