본문 바로가기
other/linux

MySQL configuration not found at /etc/mysql/my.cnf. Please create one.

by seohan1010 2025. 12. 30.
#디렉터리 복구 
sudo mkdir -p /etc/mysql
sudo mkdir -p /etc/mysql/conf.d
sudo mkdir -p /etc/mysql/mysql.conf.d

#my.cnf 파일생성 
sudo tee /etc/mysql/my.cnf >/dev/null <<'EOF'
[mysqld]
user = mysql
pid-file = /run/mysqld/mysqld.pid
socket = /run/mysqld/mysqld.sock
datadir = /var/lib/mysql
log-error = /var/log/mysql/error.log

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
EOF

#런타임 디렉터리 생성 
sudo mkdir -p /run/mysqld
sudo chown mysql:mysql /run/mysqld
sudo chmod 755 /run/mysqld

#디렉터리 소유자/권한 설정 
sudo chown -R mysql:mysql /var/lib/mysql
sudo chmod 750 /var/lib/mysql

#mysql 재시작 
sudo systemctl start mysql
sudo systemctl status mysql --no-pager