Joe-Li-CSDN博客

原创 centos7 mysql5.7主从库配置

centos7 mysql5.7主从库配置主库配置从库配置从库常见异常如何在Centos7在线安装部署mysql5.7，点击查看教程主库配置1.修改/etc/my.cnf文件配置 //编辑文件 vim /etc/my.cnf配置2.在[mysqld]下方添加以下配置[mysqld]#服务器id (主从必须不一样)server-id=10001#打开日志(主库需要打开)，这个mysql_log-bin名称可自定义、可加路径log-bin=mysql-log-bin#从库可以同步的库

2021-01-13 17:11:24 277

原创 Centos7在线安装部署mysql5.7

Centos7在线安装部署mysql5.7安装mysql安装依赖再次安装mysql服务查看root默认密码修改密码登录mysql修改密码出现以下错误需先修改规则再次修改密码授权访问权限安装mysql yum -y install mysql-community-server出现以下错误，则需先安装依赖安装依赖 //下载依赖 wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm //安装依赖 rpm

2021-01-13 12:11:00 445

原创 Centos7 安装redis5.0.8之集群教程

这里写自定义目录标题Centos7 安装redis5.0.8教程集群部署配置跳转创建集群配置文件夹拷贝redis.conf文件到redis-cluster，分别为6001.conf，6002.conf,6003.conf,6004.conf,6005.conf,6006.conf，并修改各个配置启动服务创建集群开放端口Centos7 安装redis5.0.8教程 Redis的安装教程查看：[https://blog.csdn.net/qq_39228576/article/details/1069395

2021-01-06 15:07:32 437 1

原创 mysql5.7错误 this is incompatible with sql_mode=only_full_group_by问题解决

centos7环境的mysql5.7执行下group语句select tb1.name,sum(1) as numfrom table_1 tb1 GROUP BY tb1.name 错误提示：SELECT list is not in GROUP BY clause and contains nonaggregated column ‘***’ which is not functionally dependent on columns in GROUP BY clause; this is i

2020-07-24 14:07:14 315

原创 Cenos7 安装部署rabbitmq 3.8.1

本文只是记录个人安装过程一、安装erlang//安装socatyum -y install socat//安装erlang依赖yum install -y epel-release//下载erlangwget https://packages.erlang-solutions.com/erlang/rpm/centos/7/x86_64/esl-erlang_22.1-1~centos~7_amd64.rpm//安装erlangyum install esl-erlang_22.1-

2020-07-18 11:03:07 238

原创 Centos7 修改mysql5.7最大连接数

版本：centos7,mysql5.71.编辑mysql配置文件//编辑mysql配置文件vim /etc/my.cnf//在[mysqld]下添加max_connections=100002.编辑mysqld.service配置文件//编辑/usr/lib/systemd/system/mysqld.service配置文件vi /usr/lib/systemd/system/mysqld.service//在尾部添加LimitNOFILE=65535LimitNPROC=

2020-06-24 16:57:30 1851 1

原创 Centos7 安装redis5.0.8教程

Centos7 安装redis5.0.8教程1. 安装依赖包2. 下载最新版redis安装包并解压安装3. 打开 redis.conf 并更改配置文件4.创建redis命令软连接5.增加启动服务脚本6.设置开机启动7.设置允许远程访问8.相关命令1. 安装依赖包yum install -y gcc gcc-c++2. 下载最新版redis安装包并解压安装// 跳转目录cd /usr/local/src//下载安装包wget http://download.redis.io/release

2020-06-24 11:42:03 2572 1

原创 WARN:Cannot find template location(s): [classpath:/templates/] (please add some templates, check you

Cannot find template location(s): [classpath:/templates/] (please add some templates, check your FreeMarker configuration, or set spring.freemarker.checkTemplateLocation=false)

2018-12-14 14:49:38 9546 3

原创 WARN: Establishing SSL connection without server's identity verification is not recommended.

WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default i...

2018-12-14 10:27:35 600

qq_39228576的博客