[mysql] utf8mb4 적용
character_set_client = utf8mb4 character_set_connection = utf8mb4 character_set_database = utf8mb4 character_set_filesystem = binary character_set_results = utf8mb4…
Read Morecharacter_set_client = utf8mb4 character_set_connection = utf8mb4 character_set_database = utf8mb4 character_set_filesystem = binary character_set_results = utf8mb4…
Read MoreMilliseconds 입력 방법 mysql or mariadb를 이용하며 milliseconds를 입력하지 못하는현상을 개선하지 못하고 사용하였으나 최근 사용하는…
Read MoreMariadb java client does not support useServerPrepStmts Epic Name: Use server prepareStatement Sprint: Sprint connector/j…
Read MoreUSE one option ! ==================–single-transactionex> mysqldump –user=root –password –single-transaction /*하나의 트랜잭션을 이용하여 Dump진행*/ –routines /*프로시저포함*/…
Read More<로그인 할 사용자 생성> mysql>insert into user(host,user,password) values(‘접속허용할 호스트네임 or IP’,’root’,password(‘패스워드’)); <권한주기> mysql> grant all…
Read More