DaoWiki（基于Django）开发笔记 20231113-2

MySql配置

• 服务器：阿里云 ubuntu22.04
• mysql版本: 8.0.35

安装指令

apt update
apt upgrade
apt install mysql-server
1
2
3

启动MySql服务

systemctl start mysql
1

配置开机启动MySql

systemctl enable mysql
1

登录MySql

mysql -uroot
1

创建数据库

create database dao_wiki;
show databases;
1
2

切换数据库

USE dao_wiki;
SELECT database();
1
2

创建用户鉴权表

CREATE TABLE authentication (
    -> user_id VARCHAR(255) PRIMARY KEY,
    -> email VARCHAR(255) NOT NULL,
    -> password VARCHAR(255) NOT NULL,
    -> token VARCHAR(255)
    -> );
1
2
3
4
5
6

插入测试数据

INSERT INTO authentication (user_id, email, password, token) VALUES ('eniac', 'chengminglong0525@gmail.com', '1234567890', NULL);
COMMIT;
1
2

查询测试数据

SELECT user_id, email, password, token FROM authentication;
1