Installing MySQL 5.7 database through binary package

1. Download mysql binary installation package and dependency package wget http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-devel-0.3.109-13.el7.x86_64.rpm wget http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.25-linux-g ...

Posted by uproa on Wed, 23 Oct 2019 13:51:44 -0700

CentOS install MySQL 8. X

MySQL installation (4, 5, 6 can be omitted) Declaration: CentOS version is 7.6, MySQL version installed is 8.0.17 1. First, uninstall mysql, including MariaDB. rpm -pa | grep mysql #Use 'rm -rf file name' to delete the found results, and skip if not rpm -pa | grep mariadb #Use 'rm -rf file name' to delete the found results, and skip if not fi ...

Posted by seavers on Mon, 21 Oct 2019 20:41:33 -0700

Centos7 forgot the root password of mysql

1. Stop mysql service first ​[root@CentOS ~]# ps -ef | grep mysql root 5365 1 0 15:47 pts/0 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/CentOS.pid mysql 5452 5365 4 15:47 pts/0 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --d ...

Posted by designationlocutus on Mon, 21 Oct 2019 08:56:31 -0700

Application of YUM Source Configuration and Related Problems under Centos

yum source configuration is often used in work, especially when installing databases, it is time-consuming to install dependency packages one by one, so it is enough to configure yum installation directly. 1. yum configuration instructions (reprinted in this section) The configuration file for yum is divided into two parts: main and repositor ...

Posted by zimmo on Mon, 14 Oct 2019 17:46:04 -0700

oracle update operation one or two

os: centos 7.6 db: oracle 19.3 Preparation data Create table -- drop table tmp_t0; create table tmp_t0 ( id VARCHAR2(100), name VARCHAR2(100), memo VARCHAR2(100) ) ; -- drop table tmp_t1; create table tmp_t1 ( id VARCHAR2(100), name VARCHAR2(100) ) ; insert data insert into tmp_t0 val ...

Posted by nikosft on Sun, 13 Oct 2019 12:21:03 -0700

Enterprise Essentials-Linux Centos7 Remote YUM Warehouse Deployment

Purpose of this chapter: Client Centos7-1 can enjoy the YUM repository of remote server Centos7 This chapter environment: a server Centos7, a client Centos7-1, VM Virtual Machine 1. Install vsftpd service [root@localhost ~]# yum install vsftpd -y Loaded plug-ins: fastest mirror, langpacks Loading mirror speeds from cached hostfile * base: m ...

Posted by joshmmo on Mon, 07 Oct 2019 18:25:42 -0700

Linux system oraclelinux redhat centos ubuntu debian mirror Download

1,Oracle Linux(Download address) (1)OracleLinux-Release6-Update0-x86_64-dvd.iso(2)OracleLinux-Release6-Update1-x86_64-dvd.iso(3)OracleLinux-Release6-Update2-x86_64-dvd.iso(4)OracleLinux-Release6-Update3-x86_64-dvd.iso(5)OracleLinux-Release6-Update4-x86_64-dvd.iso(6)OracleLinux-Release6-Update5-x86_64-dvd.iso(7)OracleLinux-Release6-Update6-x86 ...

Posted by Stickybomb on Sun, 06 Oct 2019 07:52:23 -0700

Automatically install CentOS 7.6 using PXE

I. demand Base new to 300 servers, need to install the operating system version 7.6 of CentOS, choose to use PXE for batch installation. II. Preparations Use the layer-2 switch to connect the server without the operating system installed, so as to avoid affecting the normal server of the current network. Upload the operating system image to ...

Posted by karenn1 on Sat, 05 Oct 2019 14:47:46 -0700

Implementation of GTID Function Experiments by Binary Installation of MySQL 5.7

Environmental Science: 192.168.205.37: as master server 192.168.205.47: as slave server Edition: OS: centos 7 1810 with mini install mysql-5.7.26-el7-x86_64.tar.gz Purpose: GTID(global transaction ID) global transaction identifier, MySQL 5.6 version began to support, GTID replication, unlike traditional replication (asynchronous delayed re ...

Posted by El_Dudereno on Fri, 04 Oct 2019 18:28:19 -0700

SHELL script PPT script

Write on the premise that you can use it 1. Determine the type of all files in / var / directory [root@linux1 scripts]# cat filetype.sh #!/bin/bash for i in $(find /var);do if [ -b $i ];then echo "$i It's a block device." elif [ -c $i ];then echo "$i It's a character device." elif [ -f $i ];then echo "$i It's an or ...

Posted by FatStratCat on Thu, 03 Oct 2019 09:48:53 -0700