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

1. Config server.cnf add$ sudo vi /etc/my.cnf.d/server.cnf----------------------------------------------------[mariadb]lower_case_table_names=1---------------------------------------------------- 2. MariaDB service restart$ sudo systemctl restart mariadb

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) downloadhttps://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html 2. ojdbc8.jar Nexus 3.23.x UploadNexus login : http://localhost:8081 Sign inleft 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.xml add..

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 editC:\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..

$ 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 )