1. 다운로드 페이지 접속 https://mariadb.org/download/ Download MariaDB Server - MariaDB.org REST API Release Schedule Reporting Bugs … Continue reading "Download MariaDB Server" mariadb.org 2. OS 및 설치버전 선택 3. /etc/yum.repos.d경로에 mariadb.repo추가 # MariaDB 10.3 CentOS repository list - created 2022-07-19 04:26 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB baseurl = https://tw1.mirror.blendbyt..

vi my.cnf [mysqld] ssl-ca = /home/mysql/fullchain3.pem ssl-key = /home/mysql/privkey3.pem ssl-cert = /home/mysql/cert3.pem service restart mysqld or mariadb MariaDB [(none)]> show variables like '%ssl%'; +---------------------+-----------------------------+ | Variable_name | Value | +---------------------+-----------------------------+ | have_openssl | YES | | have_ssl | DISABLED | | ssl_ca | /h..

SELECT count(*) FROM [table] WHERE [date_colum]

1. simple_pasword_check 설정 확인 plugin 디렉토리 확인 MariaDB [sensmail]> show global variables like 'plugin_dir%'; +---------------+------------------------+ | Variable_name | Value | +---------------+------------------------+ | plugin_dir | /usr/lib/mysql/plugin/ | +---------------+------------------------+ 1 row in set (0.01 sec) # cd /usr/lib/mysql/plugin # ls -l | grep simple_password* -rw-r--r-- 1 ..

데이터베이스 character set 확인 show create database 데이타베이스명 데이터베이스의 character set 변경 alter database 데이타베이스명 default character set = utf8 테이블 character set 확인 show create table 테이블명 테이블의 character set 변경 alter table 테이블명 default character set = utf8 각 컬럼별 character set 확인 show full columns from 테이블명 각 컬럼별 character set 변경 alter table 테이블명 \ modify column 컬럼명 varchar(20) character set utf8 collate utf8_g..