记录部署腾讯云服务器的过程
redis连接:
腾讯云服务器redis的远程连接_svllen的博客-CSDN博客_redis 远程访问
注意改文件中时bug:
这两个文件都要修改
当桌面程序客户端连接redis服务时,可能会报错,错误:
1、Connection error: Connection refused,解决办法:
修改配置文件/etc/redis.conf,并注释掉bind 127.0.0.1这一行。
2、Connection: Connection error: The remote host closed the connection,解决办法:
修改配置文件/etc/redis.conf,将protected-mode为no。
原文链接:https://blog.csdn.net/She_lock/article/details/80583234
mysql从搭建到连接:
mysql和redis部署在裸机上:
首先:安装一个软件:
然后再将原有的mysql和redis安装包复制粘贴到服务器端:
首先进行mysql的部署:
mysql数据库安装(详细)_体会!的博客-CSDN博客_mysql安装
注意这篇博客中的my.ini文件中
# 设置mysql的安装目录
basedir = D:\\mysql\\mysql-8.0.17-winx64
# 设置mysql数据库的数据的存放目录
datadir = D:\\mysql\\mysql-8.0.17-winx64\\data
这中间的双斜杠有问题,改为单斜杠才是正常的
在过程中发现已经有了data文件:
所以就进行了下面的操作:
[Can‘t connect to MySQL server on ‘localhost:3306‘ (10061) 简洁明了的解决方法_Squito的博客-CSDN博客](https://blog.csdn.net/weixin_41331140/article/details/119409805?ops_request_misc=%7B%22request%5Fid%22%3A%22166675285016782428622891%22%2C%22scm%22%3A%2220140713.130102334…%22%7D&request_id=166675285016782428622891&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2allbaidu_landing_v2~default-1-119409805-null-null.142v59pc_rank_34_2,201v3control_1,213v1t3_esquery_v1&utm_term=cannot connect to mysql server on localhost%3A3306&spm=1018.2226.3001.4187)
随后就连接好了,但是navicat仍然不能连接上数据库,于是:
在腾讯云上将mysql的端口开放:
解决的一个bug:
在mysql搭建好以后,用navicat始终连接不到mysql,解决办法:
在云服务器端开启mysql的端口
控制台链接:服务器 - 轻量应用服务器 - 控制台 (tencent.com)
操作失败, ### Error querying database. Cause: java.sql.SQLSyntaxErrorException:
Expression #1 of
SELECT list is not in GROUP BY clause and contains nonaggregated column 'jeecg-boot.c.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
### The error may exist in file [D:\Program Files (x86)\Java_project\BackEnd\market-core\target\classes\com\cug\gis\mapper\xml\ComplaintInformationMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT c.id AS id, s.store_name AS storeName, s.telephone AS storeTelephone, c.create_time AS createTime FROM complaint_information c LEFT JOIN store_information s ON s.id = c.store_id WHERE c.regulate_state = 0 OR c.regulate_state = 2 GROUP BY s.id
### Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jeecg-boot.c.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ; bad SQL grammar [];
nested exception is java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jeecg-boot.c.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决办法:
对于用安装包来安装mysql的情况: