Install MySQL-5.7.18RPM Bundle under CentOS 7.2 (applicable to the latest version of 5.7.20)

1, Environment 1. Operating system: CentOS Linux release 7.2.1511 (Core) minimized installation version 2. MySQL version: MySQL-5.7.18 (mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar ) 2, Installation process 1. Install wget. [root@Geeklp-MySQL ~]# yum -y install wget 2. Download the installation package. wget -c ...

Posted by mrmitch on Sat, 30 May 2020 09:44:20 -0700

Three ways to check the normal running time of MySQL/MariaDB database on Linux - Zhihu

Each service has its own command to check the uptime of the service. But you can also use other commands for this. Source: https://linux.cn/article-12263-1.html By Magesh Maruthamuthu Translator: geekpi We all know the purpose of using the uptime command in Linux. It is used for checking Linux system uptime And the time s ...

Posted by kevinritt on Fri, 29 May 2020 17:56:15 -0700

Java combines query operations with connected databases (20.5.29)

IDEA Connect to MySQL Database Add MySQL database connector to project Using mysql-connector-java-8.0.15.jar as an example, add jar files to your project The JDBC-MySQL connector is now added successfully Create the appropriate connection Connect the corresponding class in the jar file try { ...

Posted by pellky on Fri, 29 May 2020 11:57:32 -0700

Build the spring cloud microservice framework: VI. database persistence layer - spring datajpa

Build microservice framework (database persistence layer spring datajpa) Used to Mybatis, this time for a change, integrate spring datajpa in SQuid. Source address: Build microservice framework (database persistence layer spring datajpa) Github address: SQuid introduce I've heard of HibernateJPA before, but I've never used it. Mybatis i ...

Posted by vimukthi on Fri, 29 May 2020 04:31:05 -0700

Database optimization of MySQL

No matter what kind of service, its optimization is nothing more than from two aspects, the first is the optimization of hardware, the second is the optimization of the system and the service itself.1, Query the number of times to connect to the MySQL server mysql> show status like 'connections'; +---------------+-------+ | Variable_name | ...

Posted by tukon on Fri, 29 May 2020 04:14:48 -0700

Linux system CentOS 6.9 x64 configures jdk and MySQL 8.0 environment and grants MySQL remote access

Blogger server version and installed jdk and mysql versions: System: CentOS 6.9 jdk: jdk1.8_221 MySQL: mysql8.0.20 Relevant files needed in the configuration process (click to download from Baidu cloud): jdk: jdk-8u221-linux-x64.tar.gz (extraction code: kkp7) mysql: mysql-8.0.20-1.el6.x86_64.rpm-bundle.tar (extraction code: 0pvh) Softwar ...

Posted by daydreamer on Tue, 26 May 2020 23:56:40 -0700

Introduction to using MySQL's own tools

In MySQL, there are many powerful tools, such as mysql, mysqladmin, mysqldump, etc.1. mysql commandThe Mysql command is the most common command tool used to provide a command line interface for users to operate and manage MySQL servers.You can see how it's used in more detail through mysql --help.1) Grammar used for -e, -u, -p, -h, -P, and so ...

Posted by Spudgun on Tue, 26 May 2020 10:54:08 -0700

Oracle Query_Form Query

Previously, we detailed the changes and additions to Oracle. Today let's go on to learn more about Oracle's queries. Queries in Oracle are a big deal!!! Follow the steps of brilliant sir, move, move ~~   Small bag of knowledge Before that, let's talk about a little bit of Oracle commentary, which is very helpful for our development, oh!!! ...

Posted by boyakasha on Tue, 26 May 2020 10:43:55 -0700

MyBatis code generator - based on Maven plug-in

MBG is the official code generator of MyBatis. MBG can automatically generate entity classes, Mapper interfaces and corresponding XML files, which can reduce the workload of developers to a certain extent. This paper introduces how to use MBG Maven plug-in. 1, In pom files, dependency packages and plug-ins are introduced. <dependency ...

Posted by WormTongue on Tue, 26 May 2020 10:01:20 -0700

[original] CentOS 7 builds multiple instances of MySQL 8 (want to do several)

cause   Recently, the project began to be reconstructed, which may use the situation that the master-slave plus read-write separation. I wanted to build a local one first to try the effect. As a result, baidu found a lot of them, but few of them went to the pit. Most of them were copying other people's content. The key is that there will be e ...

Posted by windjohn on Mon, 25 May 2020 21:57:20 -0700