우분투 저장소에 10.0.1 이 기본으로 제공되므로 10.0.1을 사용하는게 좋다는 안내문구.
MariaDB 10.3
저장소 키 등록
sudo apt-get install software-properties-common
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://ftp.harukasan.org/mariadb/repo/10.3/ubuntu bionic main'
저장소 등록
sources.list 하단에 저장소정보를 추가한다.
vi /etc/apt/sources.list
# MariaDB 10.3 repository list - created 2018-07-13 09:23 UTC
# http://downloads.mariadb.org/mariadb/repositories/
deb [arch=amd64,arm64,ppc64el] https://ftp.harukasan.org/mariadb/repo/10.3/ubuntu bionic main
deb-src https://ftp.harukasan.org/mariadb/repo/10.3/ubuntu bionic main
업데이트
sudo apt -y update
... 1 package can be upgraded. Run 'apt list --upgradable' to see it.
# 메세지 안내에 따라서 목록 업그레이드
apt list --upgradable
Listing... Done
mysql-common/unknown,unknown,unknown 1:10.3.8+maria~bionic all [upgradable from: 5.8+1.0.4]
N: There is 1 additional version. Please use the '-a' switch to see it
# 안내 메세지 따라서...
apt list --upgradable -a
Listing... Done
mysql-common/unknown,unknown,unknown 1:10.3.8+maria~bionic all [upgradable from: 5.8+1.0.4]
mysql-common/bionic,now 5.8+1.0.4 all [installed,upgradable to: 1:10.3.8+maria~bionic]
# 위 내용은 10.3.8 설치가 가능하다는 메세지.
Installation
sudo apt install mariadb-server
....
root 비밀번호 등록/확인
....
# 설치완료
# 보안설정
suod mysql_secure_installation
반응형
'db > mysql' 카테고리의 다른 글
mysql8 password() (0) | 2022.04.01 |
---|---|
mysql set user password (0) | 2019.11.13 |
MySQL, MariaDB 10.2.x Upgrade After /home Restart Error (0) | 2018.07.14 |
Access denied; SUPER privilege(s) for this operation (0) | 2018.04.23 |
slow-query select in table (0) | 2018.04.21 |