SSL Connection in Mysql
SSL Connection in Mysql
The following is from the network reference and self-test collation, did not find the relevant information. If there are any mistakes, please correct them.
Current Mysql client versions are basically not able to support caching_sha2_password authentication. With Mysql 8.0, it is recommended to add parameters:
defa ...
Added by greenhorn666 on Sat, 13 Jul 2019 23:55:20 +0300
php design mode-registry tree mode
php registry tree mode
1. What is the registration tree mode?
Registered Tree mode registers object instances on the global object tree, removing objects from the global object tree when needed, just like buying candied gourds when you were a kid. Candied gourds are put on a big stick and people take them off when they buy them. The differenc ...
Added by phpr0ck5 on Sat, 13 Jul 2019 19:44:38 +0300
CentOS 6.5 source installation ZABBIX 3.0.8
1. Installing PHP and Extension Packagerpm -Uvh http://mirror.webtatic.com/yum/el6/latest.rpm
yum -y install php56w php56w-gd php56w-mysql php56w-bcmath php56w-mbstring php56w-xml php56w-ldap2. Install mysql and configure itrpm -ivh http://dev.mysql.com/get/mysql-community-release ...
Added by bob_dole on Sat, 13 Jul 2019 02:33:31 +0300
Summary and Practice of Mysql Optimistic Lock
Optimistic Lock Introduction:
Optimistic Locking is a relative pessimistic lock. Optimistic Locking assumes that data will not conflict in general. Therefore, when data is submitted and updated, it will formally detect the conflict of data. If conflict is found, it will let the user return the wrong information and let the user decide. What to ...
Added by motofzr1000 on Fri, 12 Jul 2019 20:39:07 +0300
DBCP and CP30 Connection Pool Components
I. Overview
Usually, when operating a database, users want to request a connection from the database, and it usually takes a relatively large amount of resources and a long time to create a connection. If a website has millions of visits per day, the database server needs to create millions of connections. This is extremely important for datab ...
Added by huszi001 on Fri, 12 Jul 2019 03:24:50 +0300
Python 3 reads passwords in sqlyog configuration files
What is the purpose of this person?
I have more or less heard some safety circle bulls say similar ideas, to the effect that they can scan configuration files of various programs and services (such as SVN files, RSYNC configuration files, etc.).
Find sensitive information from it, and then find the breakthrough of intrusion. Along the same line ...
Added by nightowl on Thu, 11 Jul 2019 23:05:03 +0300
Window Builds a Jenkins+SonarQube Continuous Integration Platform from scratch
Windows builds Jenkins + SnoarQube from scratch
This document does not currently contain publishing-related knowledge points.
Continuous Integrated Environment: Jenkins
Required system environment: java 8 and above, configure java-related environment variables (skipped here)
Code hosting: Git 2.22 or gitlab
Review tool: SonarQube
The to ...
Added by mattachoo on Thu, 11 Jul 2019 21:17:51 +0300
An overview of the more useful jar packages for Java Web
(Import the driver jar package for this database before connecting to it, for example MySQL is mysql-connector-java-5.1.46.jar)
About the database connection pool c3p0 jar package that connects to the database:
c3p0-0.9.5-pre1.jar dependent mchange-commons-java-0.2.4.jar itcast-tools-1.4.jar (where a JdbcUtils tool class is used to connect)
...
Added by iffo on Thu, 11 Jul 2019 19:58:42 +0300
Docker Introduction (1) - Warehouses, Containers, Mirrors
Docker is an open source application container engine that allows developers to package their applications and dependencies into a portable container and then publish them to any popular Linux machine, as well as virtualization. Containers are completely sandboxed and do not have any interfaces with each other.
The advent of Docker has allowed ...
Added by radhoo on Sun, 07 Jul 2019 04:55:51 +0300
Ubuntu 16.04's hard journey to configure mysql and modify storage paths
I used to use mysql on windows, now I use mysql on ubuntu16 and install workbench.
1) Installation process
The installation process is relatively simple.
sudo apt-get update
sudo apt-get install mysql-server mysql-client
You can install mysql well, and do not need to go to the mirror download and install it manually step by step. That req ...
Added by pyr on Sun, 07 Jul 2019 03:25:29 +0300