app 原型
https://7ynycc.axshare.com
密码
123456

爬虫机器人公会管理后台
https://1qzzji.axshare.com
密码
123456

主播管理后台
https://yqidkh.axshare.com
密码
123456

线上密码

服务器ip：119.23.241.96，密码：Hechang2023


这个是第三方的tiktokAPI接口，可以读取用户的各种信息和短视频信息
https://rapidapi.com/Sonjik/api/tokapi-mobile-version
api 用来获取主播信息

会议记录 介绍项目背景
主题: 项目基本介绍
日期: 2023-02-11 17:13:13
录制文件：https://meeting.tencent.com/v2/cloud-record/share?id=16f812e2-b2f5-47ff-8045-1ccc70c56ca6&from=3


公会后台仓库
https://gitee.com/sunhappy0318/live_gonghuiadmin.git

主播后台管理仓库
https://gitee.com/sunhappy0318/live_zhuboadmin.git



【金山文档】 公会相关库表统计
https://kdocs.cn/l/cbWRcrRoocoA

【金山文档】 后台api接口
https://kdocs.cn/l/caEjvfLygrTo

【金山文档】 爬虫机器人与后台交互流程
https://kdocs.cn/l/cpKhuAG4OmY7

//mysql root 密码 zhaozhikuan
mysql root 密码 ddykZC8MeDiwSfYJ

用户名gh_tw_ceshi  密码wYme4TbzMSbYtCmP
用户名livestreamer 密码kL5csEFtSaGDi852

mysql -uroot -pzhaozhikuan

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '481022ddf4b8fa3b';

119.23.241.96
正式数据库
gh_tw 数据库
gh_tw 用户
i94aeghtwhQQhder   密码

测试数据库
gh_tw_ceshi 数据库
gh_tw_ceshi 用户
i94aeghtwhQQhder   密码

CREATE USER 'ceshi11'@'%' IDENTIFIED BY 'i94aeghtwhQQhder';
grant all privileges on ceshi11.* to 'ceshi11'@'%' with grant option;
flush privileges;


CREATE USER 'gh_tw_ceshi'@'%' IDENTIFIED BY 'i94aeghtwhQQhder';
grant all privileges on gh_tw_ceshi.* to 'gh_tw_ceshi'@'%' with grant option;
flush privileges;



CREATE USER 'test23'@'%' IDENTIFIED BY 'i94aeghtwhQQhder';
grant all privileges on test23.* to 'test23'@'%' with grant option;
flush privileges;


CREATE USER 'gh_tw_ceshi2'@'%' IDENTIFIED BY 'i94aeghtwhQQhder';
grant all privileges on gh_tw_ceshi.* to 'gh_tw_ceshi2'@'%' with grant option;
flush privileges;


ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password
BY 'password';


ALTER USER 'gh_tw'@'%' IDENTIFIED WITH mysql_native_password
BY 'i94aeghtwhQQhder';
flush privileges;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'zhaozhikuan';
flush privileges;