:::: gangserver's blog ::::

postgresql-contrib install $ sudo yum install postgresql12-contrib

# Install the repository RPM: $ sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Install PostgreSQL: $ sudo yum install -y postgresql12-server # Optionally initialize the database and enable automatic start: $ sudo /usr/pgsql-12/bin/postgresql-12-setup initdb $ sudo systemctl enable postgresql-12 $ sudo systemctl start po..

$ sudo apt install mariadb-server $ sudo mysql_secure_installation

1. Oracle JDBC driver 12.2.0.1 (ojdbc8.jar) download https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html 2. ojdbc8.jar Nexus 3.23.x Upload Nexus login : http://localhost:8081 Sign in left menu [Upload] Click -> [maven-releases] click - File : [Browse] ojdbc8.jar select - Extension : jar - Group ID : com.oracle.jdbc - Artifact ID : ojdbc8 - Version : 12.2.0.1 [Upload] 3. pom...

MariaDB 10.3 login error $ mariadb -u root -pEnter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' $ sudo mariadb -u root -p (or sudo mysql -u root -p) after login MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PassW0rd';Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> FLUSH PRIVILEGES;Query OK, 0 rows affected (0.001 sec) re-log..

Oracle Install Directory : C:\app\oracle\product\12.2.0\dbhome_1 listener.ora edit C:\app\oracle\product\12.2.0\dbhome_1\network\admin\listener.ora Before SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\app\oracle\product\12.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\oracle\product\12.2.0\dbhome_1\bin\oraclr12.dll") ) ) LISTENER = (D..

$ 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] http://mirror.nodesdirect.com/mariadb/repo/10.4/ubuntu bionic main' $ sudo apt update$ sudo apt install mariadb-server $ sudo vi /etc/apt/sources.list.d/MariaDB.list# MariaDB 10.4 repository list - c..

MariaDB 10.4 yum repository $ sudo vi /etc/yum.repos.d/MariaDB.repo----------------------------------------------------------------------------------------# MariaDB 10.4 CentOS repository list - created 2019-11-20 13:09 UTC# http://downloads.mariadb.org/mariadb/repositories/[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.4/centos7-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaD..

begin transaction ( or begin tran ) 작업1 작업2 . . . 성공시 commit tran ( or commit ) 실패시 rollback tran ( or rollback )