分类: LiteHub | 阿寒的学习笔记

禁用自动更新

sudo systemctl stop apt-daily.timer
sudo systemctl stop apt-daily-upgrade.timer
sudo systemctl disable apt-daily.timer
sudo systemctl disable apt-daily-upgrade.timer

安装boost

sudo apt-get install libbz2-dev
sudo apt-get install libicu-dev
//下载地址
https://sourceforge.net/projects/boost/files/boost/1.69.0/
tar -xvf 压缩包
./bootstrap.sh
./b2
sudo ./b2 --prefix=/usr/local/boost install
//添加环境变量
vim /etc/environment

CPLUS_INCLUDE_PATH=/usr/local/boost/include
LIBRARY_PATH=/usr/local/boost/lib

Linux：编译安装boost 1.69库

安装muduo库

sudo apt install g++ cmake make libboost-dev
//下载并解压文件
./build.sh
./build.sh install
cd ../build/
cd release-install-cpp11

cd include/
mv muduo/ /usr/include/
cd ../lib
mv * /usr/local/lib/

muduo网络库下载安装教程

安装mysql

sudo wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_5.7.29-1ubuntu18.04_amd64.deb-bundle.tar
sudo tar -xvf mysql-server_5.7.29-1ubuntu18.04_amd64.deb-bundle.tar
//更新依赖源
sudo apt-get update
//安装依赖包
sudo apt-get install ./libmysql*
sudo apt-get install libtinfo5


sudo apt-get install ./mysql-community-client_5.7.29-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-client_5.7.29-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-community-server_5.7.29-1ubuntu18.04_amd64.deb 
sudo apt-get install ./mysql-server_5.7.29-1ubuntu18.04_amd64.deb

//连接数据库
mysql -u root -p

//开启远程访问
use mysql;
select User,Host from user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;

vim /etc/mysql/mysql.conf.d/mysqld.cnf 
将Bindaddres 从127.0.0.1 改为0.0.0.0
systemctl restart mysql

Ubuntu22部署MySQL5.7详细教程

其他配置

//安装nlohmann/json
sudo apt upgrade
sudo apt install nlohmann-json3-dev

//c++ mysql 库
sudo apt install libmysqlcppconn-dev

//安装openssl开发库
sudo apt install libssl-dev

//安装ffmpeg库
sudo apt-get install ffmpeg
ffmpeg -version

//安装gzip
sudo apt-get install gzip
gzip --version

sudo apt install zlib
sudo apt install zlib1g-dev

创建表操作

//创建web数据库
create database webdb;
use webdb;

//创建用户表
create table users (
id int(11) not null auto_increment,
username varchar(255) not null,
password varchar(255) not null,
primary key(id));


//创建文件信息表
CREATE TABLE fileinfo (
    id INT AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    username VARCHAR(100) NOT NULL,
    uploadtime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    duration FLOAT DEFAULT NULL,
    isvideo   TINYINT(1) NOT NULL DEFAULT 0
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;;

//创建评论表
CREATE TABLE comments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  video_name VARCHAR(255) NOT NULL,
  user_id INT NOT NULL,
  parent_id INT DEFAULT 0,
  content TEXT NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE TABLE video_likes (
    user_id INT(11) NOT NULL,
    video_name VARCHAR(255)  NOT NULL,
    PRIMARY KEY (user_id, video_name)
)CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE TABLE video_stats (
    video_name VARCHAR(255)  NOT NULL,
    view_count INT(11) DEFAULT 0,
    like_count INT(11) DEFAULT 0,
    PRIMARY KEY (video_name)
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

//或者直接设置整个数据库使用这个字符集
ALTER DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

共创建如下几个表