安装mysql后,输入以下命令来创建相应的用户及数据库:
- mysql -u root -p
- CREATE USER '1'@'localhost' IDENTIFIED BY '123456';
- GRANT ALL PRIVILEGES ON db_fin_tech.* TO '1'@'localhost';
- FLUSH PRIVILEGES;
- exit
- mysql -u 1 -p
- CREATE DATABASE db_fin_tech;
- USE db_fin_tech;
- CREATE TABLE users ( username VARCHAR(50), nickname VARCHAR(50), password VARCHAR(50), balance FLOAT DEFAULT 1000000, stocks_held JSON, history JSON, yesterdayTotal JSON );