'Workbench'에 해당되는 글 2건

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 안될경우 설치

Mysql WorkBench 

sudo apt update

sudo apt install -y wget

wget https://dev.mysql.com/get/mysql-apt-config_0.8.15-1_all.deb

sudo dpkg -i mysql-apt-config_0.8.15-1_all.deb

Ubuntu Bionic <- 선택

sudo apt update

sudo apt install mysql-community-server

sudo systemctl enable --now mysql

systemctl status mysql