centos7 yum install mysql5.7

By default, MariaDB is installed in CentOS, which is a branch of MySQL. However, in order to meet the needs, MySQL should be installed in the system, and MariaDB can be directly overwritten after the installation. 1 download and install MySQL's official Yum Repository [root@centos7 ~]# wget https:/ ...

Posted on Wed, 05 Feb 2020 04:45:41 -0800 by emopoops

return and job management of SaltStack

Article directory 1. return of saltstack component 1.1 return process 1.2 use mysql as the return storage method 2. job cache 2.1 job cache process 2.2 job management 1. return of saltstack component The return component can be understood as the SaltStack system stores or returns data return ...

Posted on Sat, 01 Feb 2020 21:36:18 -0800 by davidx714

MySQL: MySQL installation under Linux

If you have any problems, please correct them. Thank you very much! MySQL installation steps under Linux 1. Download the installation package 2. Inspection before installation 3. Formal installation 4. Installation problems and Solutions 5. reference 1. Download the installation package Download ...

Posted on Sun, 19 Jan 2020 21:11:58 -0800 by fuzzy1

Create a new user in MySQL and grant it full access to a database

I want to create a new user in MySQL and provide full access to only one database (for example, dbTest, I use create database dbTest; such a command create database dbTest;).What do those MySQL commands do? #1st floor Try this to create a user: CREATE USER 'user'@'hostname'; Try this to access the database dbTest: GRANT ALL PRIVIL ...

Posted on Sun, 05 Jan 2020 13:02:36 -0800 by bigfunkychief

Deploy zabbix enterprise level monitoring

Introduction: zabbix is an enterprise level open source solution based on WEB interface, which provides distributed system monitoring and network monitoring functions. zabbix can monitor various network parameters to ensure the safe operation of the server system, and provide flexible notification mechanism to enable the syst ...

Posted on Wed, 01 Jan 2020 09:42:24 -0800 by phoenixx

CentOS 7.4 compiling and installing MariaDB 10.3.9

Installation environment System: Centos 7.4 Software: MariaDB 10.3.9 Dependent software: Cmake, Ncurses, Bison, Boost Create MariaDB installation directory, database storage directory, user and directory First, create a user named MySQL with no login permission and a user group named mysql, then install the dependency lib ...

Posted on Tue, 31 Dec 2019 13:29:44 -0800 by paddyhaig

MariaDB common commands summary

Since the MySQL database project was acquired by Oracle company, it has changed from open source software to "closed source" software, which leads many enterprises and manufacturers in IT industry to choose the rising star of database software - MariaDB database management system. Therefore, MariaDB database manageme ...

Posted on Sun, 29 Dec 2019 08:06:18 -0800 by leoden

Create MySQL index

Introduction: Index is a table structure that sorts the values of one or more columns in a database table. Using index can improve the query speed of specific data in the database. Index is also a separate database structure stored on disk, which contains the reference pointer to all records in the data table. Index is used to ...

Posted on Fri, 27 Dec 2019 10:26:56 -0800 by LazyJones

Compiling and installing MariaDB 10.2.26 in Ubuntu 1604

Environment preparation: Alibaba cloud ecs Under Ubuntu 1604, compile and install mariadb10-2.26 1. First install some tool software packages required by the initial test environment apt install -y iproute2 ntpdate tcpdump telnet traceroute nfs-kernel-server nfs-common lrzsz tree openssl libssl-dev \libpcre3 libpcre3-dev zlib1g-dev ntpdate ...

Posted on Sat, 14 Dec 2019 12:05:15 -0800 by stylusrose

haproxy for dynamic and static separation and load balancing of discuz Forum

I. install httpd on cs2, cs3 and cs4 [root@cs2 ~]# yum install httpd [root@cs3 ~]# yum install httpd [root@cs4 ~]# yum install httpd 2. Install php and php MySQL on cs3 and cs4 [root@cs3 ~]# yum install php [root@cs3 ~]# yum install php-mysql [root@cs4 ~]# yum install php [root@cs4 ~]# yum install php-mysql 3. Install mysql on cs5 [root@cs ...

Posted on Thu, 05 Dec 2019 10:23:35 -0800 by gijs