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