MySQL installation under CentOS
Mysql database is a common database. When you practice the installation, you may encounter various problems. Please refer to the installation method of MySQL database in CentOS system. If you have any questions, please leave a message and I will answer them at any time.
MySQL installation steps are as follows:
Step 1: upload MySQL binary instal ...
Posted by roze on Sun, 01 Dec 2019 12:26:41 -0800
01 flask initialization project
Initialize the flask environment
pip install pipenv
mkdir flasky
pipenv shell
pipenv install flask
# Install plug-ins
pipenv install flask-sqlalchemy flask-migrate flask-wtf flask-mail pymysql
mkdir app
Create an. env file. The. env file will be loaded when using pipenv
# .env
FLASK_APP=run.py
FLASK_DEBUG = 1
app initialization
Create a new in ...
Posted by Popple3 on Sun, 01 Dec 2019 08:14:23 -0800
C + + connect and use MySQL database
1. C onnect MySQL database with C + +
First, create a new C + + project in VS, right-click the project name, and select properties.
Select platform selection
Select configuration manager
Choose new
Select X64 from the drop-down menu. OK
Select C / C + + > General - > attach the include directory, and add C:\Program Files\M ...
Posted by markl999 on Sun, 01 Dec 2019 06:18:48 -0800
Using python3 to grab pinpoint application information
Using python3 to grab pinpoint application information
Pinpoint It is an APM (application performance management) tool written in Java for large distributed systems. Inspired by Dapper, Pinpoint provides a solution to help analyze the overall structure of the system and the interrelationship between its components by tracking transactions in di ...
Posted by starphp on Sun, 01 Dec 2019 04:38:45 -0800
Spring boot integrates the Jasypt security framework and encrypts the content of configuration files
Reprinted in ( https://zhiku8.com/springboot-jasypt.html)
We are clear text in the yml or properties configuration files of the spring boot project, so the security is relatively low. We all know that the configuration file contains some database connection user name and password, some third-party key and other information. So let's be careful. ...
Posted by searchman on Sat, 30 Nov 2019 14:09:47 -0800
Java advanced notes: Spring Boot integrates Mybatis
Mybatis is an excellent persistence framework that supports customized SQL, stored procedures, and advanced mapping. Mybatis avoids almost all JDBC code and manual setting of parameters and getting result sets. This article introduces the steps of integrating Mybatis with Spring Boot. MYSQL is selected as the database
Create a Spri ...
Posted by jwmessiah on Sat, 30 Nov 2019 13:34:09 -0800
Count the correct rate of answers (Mysql counts comma separated characters)
According to the answer situation of the employee's answer activity, the error rate of the questions is counted. The database has the employee's answer sheet employee's question
employee_question
And standard answer sheet
question_info
, you can see that both the standard answer and the answer situation are strings separate ...
Posted by chito on Sat, 30 Nov 2019 10:53:06 -0800
CentOS 7 deploy MySQL 5.7 (master-slave replication, traditional mode and GTID)
Record (≫); 1. Copy binary files and locations; 2. Master-slave copy based on GTID: (test environment is CentOS 7.3)
I. based on binary log file (traditional way)
(1) working principle:
1. Master records the database operation to Binary log and sends it to Slave I/O thread;
2. Slave's I/O thread stores the received Binary log to the local Rela ...
Posted by zgkhoo on Sat, 30 Nov 2019 08:01:39 -0800
MySQL Blackhole: black hole engine
Check the output of SHOW ENGINES; or SHOW VARIABLES LIKE 'have%'; to see whether the previous mysql version supports this engine.
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment ...
Posted by chriswheat on Sat, 30 Nov 2019 05:13:34 -0800
mysql no backup recovery
Environment: centos 7.4+ mysql 5.7.19
When the database is damaged without backup, the data can be recovered from the disk file, which may not be 100% successful. The tool used is undo-for-innodb-master.zip
First, recover the table structure from frm (using MySQL utilities tool)
1. Install MySQL utilities
#yum localinstall mysql-connector-pytho ...
Posted by kirannalla on Sat, 30 Nov 2019 04:26:02 -0800