'MariaDB'에 해당되는 글 3건

sudo apt -y install software-properties-common gnupg2

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8

echo "deb [arch=amd64] http://mariadb.mirror.liquidtelecom.com/repo/10.4/debian buster main" | sudo tee /etc/apt/sources.list.d/mariadb.list

sudo apt update

sudo apt install mariadb-server mariadb-client

sudo mysql_secure_installation 비밀번호 설정
mysql -u root -p

sudo systemctl enable mariadb

워크벤치 설정
apt-get install mysql-workbench-community

plasma5 snap 설치 
sudo snap install mysql-workbench-community

외부접속
mysql -u root -p
grant all privileges on*.* to 'root'@'%' identified by 'DB 비밀번호';
use mysql
select host,user, password  from user;

% root 추가됨
flush privileges; 저장
Mysql-Workbench 실행
localhost 127.0.0.1로 접속 테스트

mysql workbench 접속 안될경우 확인
gedit /usr/bin/mysql-workbench
WB_NO_GNOME_KEYRING=1 //주석 삭제 
systemctl restart mysql

apt install gnome-keyring 안될경우 설치

MariaDB

sudo apt update && sudo apt upgrade

sudo apt -y install software-properties-common gnupg2

sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8

echo "deb [arch=amd64] http://mariadb.mirror.liquidtelecom.com/repo/10.4/debian buster main" | sudo tee /etc/apt/sources.list.d/mariadb.list

sudo apt update

sudo apt install mariadb-server mariadb-client

mysql-common 패키지를 설치했다면 제거해야 할 수도 있습니다.
sudo apt remove mysql-common

sudo systemctl enable --now mariadb

sudo mysql_secure_installation 

mysql -u root -p