amazon linux2へ各種DBクライアントインストール

[MySQL 8]
https://qiita.com/tamorieeeen/items/d9b2af588f1dfd43120d

sudo yum -y remove mariadb-libs

sudo yum -y localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

sudo yum-config-manager --disable mysql57-community
sudo yum-config-manager --enable mysql80-community

sudo yum info mysql-community-client

sudo yum -y install mysql-community-client

mysql --version

mysql -h mysql01.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -P 3306 -u root -p


[PostgreSQL 13]

amazon-linux-extras list | grep postgresql
sudo amazon-linux-extras install postgresql13

psql --version

psql -h postgresql01.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -p 5432 -U postgres


[Oracle 19c]
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

Basic Package (RPM)
SQL*Plus Package (RPM)

sudo yum -y install https://download.oracle.com/otn_software/linux/instantclient/1912000/oracle-instantclient19.12-basic-19.12.0.0.0-1.x86_64.rpm
sudo yum -y install https://download.oracle.com/otn_software/linux/instantclient/1912000/oracle-instantclient19.12-sqlplus-19.12.0.0.0-1.x86_64.rpm

sudo yum -y install https://download.oracle.com/otn_software/linux/instantclient/1912000/oracle-instantclient19.12-tools-19.12.0.0.0-1.x86_64.rpm

sqlplus oracle@oracle01.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com:1521/ORCL


[SQL Server 2019]

sudo curl https://packages.microsoft.com/config/rhel/7/prod.repo -o /etc/yum.repos.d/msprod.repo


sudo ACCEPT_EULA=Y yum -y install mssql-tools unixODBC-devel


echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
source ~/.bash_profile


sqlcmd -S sqlserver01.xxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -U sa