/usr/sbin/mariadbd: Can't create file '/var/log/mysql/error.log' (errno: 2 "No such file or directory")

 

#디렉터리 생성및 권한 부여 
sudo mkdir -p /var/log/mysql
sudo chown -R mysql:mysql /var/log/mysql
sudo chmod 750 /var/log/mysql

#로그파일 생성 
sudo touch /var/log/mysql/error.log
sudo chown mysql:mysql /var/log/mysql/error.log
sudo chmod 640 /var/log/mysql/error.log

#mariadb 재실행 
sudo systemctl restart mariadb
sudo systemctl status mariadb --no-pager

#로그확인 
sudo journalctl -u mariadb -n 50 --no-pager