2019년에 작성한 노트를 옮겨 적은 것입니다.
TIME FORMAT ERROR
MariaDB 10.1.7 이후로 STRICT_TRANS_TABLES 모드가 default임
mysql> set @@sql_mode=''; set @@global.sql_mode='';
mysql> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE;
default_time_zone='+9:00'
[mysqld]
sql_mode=''
default_time_zone='+9:00'
systemctl start mysql, MariaDB 시작 안될 때
MySQL 5.7 → MariaDB 10.1 에러임
참고
echo "/usr/sbin/mysqld { }" > /etc/apparmor.d/usr.sbin.mysqld
apparmor_parser -v -R /etc/apparmor.d/usr.sbin.mysqld
systemctl restart mariadb
( + sudo su )
sudo mysql로 접근 시도
&& CREATE OR REPLACE USER 'root'@'localhost' IDENTIFIED BY 'root';
RequestError: Error: socket hang up
process.env["NODE_TLS_REJECT_UNAUTHORIZED"] = 0;
RequestError: Error 402, Unauthorized
ERROR: Couldn't connect to Docker daemon at http+docker://localhost - is it running?
docker-compose up -d
했을 때.