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