LIUGUOFENG

下载地址，选择 Windows (x86, 64-bit), ZIP Archive

https://dev.mysql.com/downloads/mysql/

https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.21-winx64.zip

Continue reading MySQL 8.0.21 安装教程 windows 64位

SQL Server 实现 MySQL group_concat

注释：连表查询时，子表单字段结果拼接

select DISTINCT(o.id),o.*, 
CAST(stuff(( 
SELECT ',' + title FROM t_rm_sealapplycommondetail0 d WHERE d.pid = o.id FOR xml path('')
) , 1 , 1 , '') AS VARCHAR(255)) as titles 
from t_rm_sealapplycommon o  where 1=1 

https://s1.ax1x.com/2020/07/21/UI7xld.png
https://s1.ax1x.com/2020/07/21/UI7z6A.png
https://s1.ax1x.com/2020/07/21/UI7vSH.png
https://s1.ax1x.com/2020/07/21/UI7OYD.png
https://s1.ax1x.com/2020/07/21/UI7Xfe.png
https://s1.ax1x.com/2020/07/21/UIHSOI.png
https://s1.ax1x.com/2020/07/21/UIH9mt.png
https://s1.ax1x.com/2020/07/21/UIHC0P.png
https://s1.ax1x.com/2020/07/21/UIHPTf.png
https://s1.ax1x.com/2020/07/21/UIHFk8.png
https://s1.ax1x.com/2020/07/21/UIHktS.png
https://s1.ax1x.com/2020/07/21/UIHAfg.png
https://s1.ax1x.com/2020/07/21/UIHVpQ.png

vim /etc/init.d/mysql

到start模块，添加 –user=root 到 mysqld_safe

MySql错误：Starting MySQL…The server quit without updating PID file

https://blog.csdn.net/qq_36514672/article/details/81100981

Continue reading Struts 模板传递自己一些记录

下载地址：

https://www.oracle.com/java/technologies/javase/javase7-archive-downloads.html

选择 jdk-7u80-linux-x64.rpm

或者 https://download.csdn.net/download/misswell/12490111

Continue reading Centos 6.8 JAVA 1.7.0_80 安装

官网地址 https://dev.mysql.com/downloads/mysql/

https://dev.mysql.com/downloads/mysql/5.7.html

Continue reading MySQL 5.7.30 Winx64 安装

编译前准备，更新 yum 源包

yum update

创建用户组 www 创建用户 www 所属组 www 设置不能登录

groupadd www && useradd -g www www -s /bin/false

安装 nginx 编译所需依赖包

yum -y install zlib zlib-devel openssl* pcre pcre-devel gd-devel

Continue reading Nginx 1.12 CentOS 7 编译安装

系统 CentOS 7：

http://mirrors.aliyun.com/centos/7/isos/x86_64/

MySQL 安装

安装依赖包

yum install -y  gcc gcc-c++ cmake ncurses ncurses-devel bison
yum -y install openssl-devel

安装 MySQL ，编译安装需要 boost 库，在官网下载含 boost 的源码包

https://dev.mysql.com/downloads/mysql/5.7.html

Continue reading MySQL 5.7 CentOS 7编译安装记录

安装 SSH 并开启外部访问

sudo apt install openssh-server

启动

sudo service ssh start

编辑配置文件

vim etc/ssh/sshd_config

找到 passwordAuthentication no 把 no 改为 yes

去掉注释并将 PermitRootLogin without-password 改为 PermitRootLogin yes

Windows 子系统 WSL 开机启动服务

Linux 中创建执行脚本

sudo vim /etc/init.wsl

编辑器编写保存并赋予权限

#! /bin/sh
/etc/init.d/ssh start
/etc/init.d/mysql start
/etc/init.d/php-fpm start
/etc/init.d/nginx start 

sudo chmod +x /etc/init.wsl

Continue reading Windows 子系统 WSL 一些记录