centos7 Mysql error 모음

카테고리 없음

by 한국인맛집 2022. 5. 16. 18:54

MySQL Daemon failed to start

cd /var/lib/mysql
mv ib_logfile0 ib_logfile2
mv ib_logfile0 ib_logfile3
mv ib_logfile0 ib_logfile4
mv ib_logfile0 ib_logfile5


systemctl start mariadb mysqld

Referrence

https://m.blog.naver.com/goodjsg/220856488676

MySQL Daemon failed to start 에러 해결 방법

갑자기 MySQL이 실행이 안되는 경우가 있다. 그러면 거즘 90%는 디스크 용량이 부족하기 때문에 로그파...

blog.naver.com

[MySQL/MariaDB] - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

sudo ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Reffernce

https://linked2ev.github.io/database/2021/06/11/MySQL,-MariaDB-ERROR-2002-(HY000)-Can't-connect-to-local-MySQL-server-through-socket-'tmp-mysql.sock'-(2)/

ERROR 2002 (HY000) : Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 오류에 대한 포스팅이다.

linked2ev.github.io

Root 비밀번호 재설성

use mysql;

UPDATE mysql.user SET Password=PASSWORD('1234')
           WHERE User='root'; 

update user set password=password('1234') where user='root';

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement