설치환경 # cat /etc/redhat-release CentOS Linux release 7.9.2009 (Core) # java -version openjdk version "1.8.0_282" OpenJDK Runtime Environment (build 1.8.0_282-08) OpenJDK 64-Bit Server VM (build 25.282-b08, mixed mode) 호환성확인 www.elastic.co/kr/support/matrix Elastic Support Matrix | Elasticsearch Everything you need to launch the Elastic (ELK stack). From Oracle to IBM, Ubuntu to Windows, Firefox t..

도커버전 # docker -v Docker version 1.13.1, build 0be3e21/1.13.1 elasticsearch image 다운 # docker pull docker.elastic.co/elasticsearch/elasticsearch:7.6.2 Trying to pull repository docker.elastic.co/elasticsearch/elasticsearch ... 7.6.2: Pulling from docker.elastic.co/elasticsearch/elasticsearch c808caf183b6: Pull complete d6caf8e15a64: Pull complete b0ba5f324e82: Pull complete d7e8c1e99b9a: Pull com..

1. 로컬에서만 접속가능 계정 추가 create user '사용자'@'localhost' identified by '비밀번호'; 2. 권한 부여 2-1. 모든DB일 경우 grant all privileges on *.* to '사용자'@'localhost'; 2-2. 특정DB일 경우 grant all privileges on DB이름.* to '사용자'@'localhost'; 3. 적용 flush privileges; 4. 권한부여 확인 # userid 와 host명까지 붙여서 검색해야 함 SHOW GRANTS FOR test@localhost; SHOW GRANTS FOR test@'%'; SHOW GRANTS FOR test@'192.168.0.10'; 5. 권한 제거 # 모든 권한을 삭제 # rev..

replace(컬럼명,CHR(13)||CHR(10),'')

mysql-5.5.62 설치 # wget https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.62.tar.gz # cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.62 \ -DWITH_EXTRA_CHARSETS=all \ -DMYSQL_DATADIR=/usr/local/mysql-5.5.62/data \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DSYSCONFDIR=/etc \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_c..