'mariaDB'에 해당되는 글 2건

  1. 2020.01.07 MariaDB character set 변경 [utf8mb4]
  2. 2020.01.07 Ubuntu MariaDB 설치

기본 설정 확인


show variables like 'c%';




MariaDB 설정 변경


vi /etc/mysql/my.cnf


[client]

default-character-set=utf8mb4


[mysql]

default-character-set=utf8mb4


[mysqld]

collation-server = utf8mb4_unicode_ci

#init-connect='SET NAMES utf8mb4'

character-set-server = utf8mb4


[mysqldump]

default-character-set=utf8mb4



변경된 설정 확인


show variables like 'c%';



Posted by theqoo
,

Ubuntu 16.04.6 LTS


MariaDB 10.4 [Stable]


sudo -s

apt-get install software-properties-common

apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

add-apt-repository 'deb [arch=amd64,arm64,i386,ppc64el] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu xenial main'


sudo apt update

sudo apt install mariadb-server


https://downloads.mariadb.org/mariadb/repositories/#mirror=digitalocean-nyc


'Study > Ubuntu' 카테고리의 다른 글

AWS CLI 설치 및 삭제  (0) 2019.09.01
Ubuntu node.js v12.x 설치  (0) 2019.06.03
Ubuntu MongoDB 설치  (0) 2019.06.02
Ubuntu node.js v10.x 설치  (0) 2019.06.02
Ubuntu - 디스크 정보 확인  (0) 2015.08.13
Posted by theqoo
,