[2022.05.10] How to install mysql on ubuntu 20.04 ? (+ jdbc plugin)

[2022.05.10] How to install mysql on ubuntu 20.04 ? (+ jdbc plugin)

 

 

MySQL install (ubuntu20.04)
    a. wget dev.mysql.com/get/mysql-apt-config_0.8.20-1_all.deb
    b. sudo dpkg -i mysql-apt-config_0.8.20-1_all.deb
    c. sudo apt-get update
    d. sudo apt-get install mysql-server

 

 

 

 

sudo apt-get update 실행 시 발생하는 에러 1 (Solve)

Err:1 http://repo.mysql.com/apt/ubuntu focal InRelease                                              
  The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29

 

해결 방법

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
sudo apt-get update

 

 

 

 

sudo apt-get update 실행 시 발생하는 에러 2 (Solve)

vmadmin@vmadmin-virtual-machine:~/Desktop$ sudo apt-get update
Err:1 http://kr.archive.ubuntu.com/ubuntu focal InRelease                                                  
  Temporary failure resolving 'kr.archive.ubuntu.com'
Err:2 http://repo.mysql.com/apt/ubuntu focal InRelease                                                     
  Temporary failure resolving 'repo.mysql.com'
Err:3 http://security.ubuntu.com/ubuntu focal-security InRelease                                           
  Temporary failure resolving 'security.ubuntu.com'
Hit:4 http://kr.archive.ubuntu.com/ubuntu focal-updates InRelease                               
Hit:5 http://kr.archive.ubuntu.com/ubuntu focal-backports InRelease
Reading package lists... Done
W: Failed to fetch http://kr.archive.ubuntu.com/ubuntu/dists/focal/InRelease  Temporary failure resolving 'kr.archive.ubuntu.com'
W: Failed to fetch http://security.ubuntu.com/ubuntu/dists/focal-security/InRelease  Temporary failure resolving 'security.ubuntu.com'
W: Failed to fetch http://repo.mysql.com/apt/ubuntu/dists/focal/InRelease  Temporary failure resolving 'repo.mysql.com'
W: Some index files failed to download. They have been ignored, or old ones used instead.

→ 위의 에러가 발생했을 때 update 명령어를 다시 입력 

 

 

 

 

MySQL Status & Version 

vmadmin@vmadmin-virtual-machine:~/Desktop$ systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2022-04-27 09:19:07 KST; 6s ago


# MySQL Version Check
vmadmin@vmadmin-virtual-machine:~/Desktop$ mysql --version
mysql Ver 8.0.29 for Linux on x86_64 (MySQL Community Server - GPL)

 

 

 

 

2. jdbc plugin install

    a. wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java_8.0.29-1ubuntu20.04_all.deb
    b. sudo dpkg -i mysql-connector-java_8.0.29-1ubuntu20.04_all.deb

    * path
        - usr/share/java/mysql-connector-java-8.0.29.jar