Mariadb changes the root password and skips the authorization mode to start the database

Mariadb changes the root password By default, the password of the newly installed mariadb is empty. You can log in to the database by directly entering mysql in the shell terminal. If it is the first time you have just installed it, use the MySQL? Secure? Installation command to initialize it. # mysql_secure_installation NO ...

Added by mraza on Mon, 27 Jan 2020 17:54:03 +0200

Docker swarm single node mode

Before reading this article, make sure that you have properly containerized a machine and can deploy the container using docker compose. If not, refer to Layout document. There are two kinds of nodes in a swarm cluster, manager node and worker node. A containerized machine (either physical or virtual) ...

Added by jbdphp on Mon, 27 Jan 2020 07:56:53 +0200

Introduction to Canal - server

Canal is an incremental log resolution for MySQL database provided by Ali, which provides a framework (component) for incremental data subscription and consumption. 1. Configure the MySQL configuration file (my.ini), and add the following configuration: [mysqld] log-bin=mysql-bin #Enable log monitoring binlog-format=ROW #Monitoring mode is ...

Added by madhu on Sun, 26 Jan 2020 20:03:05 +0200

linux centos7 install mysql8

1. RPM version installation Check to see if there are other versions of the database, and if so, delete it clean Non-root users must have sudo privileges 1. Download mysql related installation packages https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql80-community-el7/mysql-community-server-8.0.18-1.el7.x86_64.rpm https://mirrors.tuna.tsing ...

Added by jmcall10 on Sat, 25 Jan 2020 10:42:23 +0200

Apache Web page and security optimization -- web page compression

Article directory Preface: 1, Apache Web page optimization 1.1 web page compression 1.1.1 overview of apcahe web page optimization 1.1.2 gzip introduction 1.1.3 Apache compression module 1.1.4 configure web compression function 2, Apache Web compression experiment 2.1 compiling apache manually ...

Added by kujtim on Wed, 22 Jan 2020 11:12:52 +0200

Experiment 4 JDBC Technology

Experiment 4 JDBC Technology 1, Objective: 1. Familiar with MySQL installation and configuration method; familiar with JDBC basic programming method; master the method of adding, deleting, modifying and querying database in web program; 2. Understand how to program database in JSP+JavaBean+Servl ...

Added by thatsme on Wed, 22 Jan 2020 10:06:31 +0200

Introduction to mysql slow log opening and analysis

1. Open Slow Query - View show variables like 'slow_query%'; show variables like 'long_query_time'; show variables like 'log_queries_not_using_indexes'; Temporarily open slow log - Open+Set uses root user, after closing the connection, re-query to see the modified value, only valid for the current service, configuration w ...

Added by kitaeshi on Tue, 21 Jan 2020 18:43:31 +0200

MYSQL recursive query, query all the parent classes according to the subclass ID (the first detailed tutorial of the universe)

Preface In the work, the business requirements encounter MYSQL recursion, and most of the online data are copied back and forth, although the code can indeed run. But Mengxin really can't understand what this SQL writes. Looking at the comments below, many people didn't reply to their questions. He ...

Added by Zay on Tue, 21 Jan 2020 07:33:12 +0200

Installing and simple using mycat 1 under windows

1.orcale downloads sdk and installs 2. Download mycat https://github.com/MyCATApache/Mycat-download 3.server.xml <?xml version="1.0" encoding="UTF-8"?> <!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the Lic ...

Added by bitman on Mon, 20 Jan 2020 08:48:27 +0200

Install Percona Server database (in CentOS 8)

Building PXC cluster under CentOS8 This paper introduces how to build Percona Server cluster. In fact, the installation package of PXC has been bundled with Percona Server, so some details of Percona Server will be masked during installation. But sometimes you may use Percona Server alone, so this article introduces the installation of Percona ...

Added by melkara on Mon, 20 Jan 2020 08:38:37 +0200