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