1、更新Ubuntu包管理器
sudo apt-get update
sudo apt-get upgrade2、安装MySQL服务器
sudo apt-get install mysql-server3、安全配置MySQL
设置root密码，移除匿名用户等
sudo mysql_secure_installation4、登录MySQL
输入你在安全配置时设置的密码
sudo mysql -u root -p5、创建数据库和表
CREATE DATABASE IF NOT EXISTS your_project_name;
USE your_project_name;假设我们需要三个表格：用户表，成就表，用户成就对照表
CREATE TABLE IF NOT EXISTS users ( id INT AUTO_INCREMENT PRIMARY KEY, openid VARCHAR(255) NOT NULL UNIQUE, unionid VARCHAR(255) UNIQUE, nickname VARCHAR(255), avatar_url TEXT, total_achievements INT DEFAULT 0, total_score INT DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, last_login_at TIMESTAMP NULL );
CREATE TABLE IF NOT EXISTS achievements ( id INT AUTO_INCREMENT PRIMARY KEY, score INT NOT NULL );
CREATE TABLE IF NOT EXISTS user_achievements ( user_id INT, achievement_id INT, achieved_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (user_id, achievement_id), FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (achievement_id) REFERENCES achievements(id) );6、创建用户，分配权限
CREATE USER 'your_user_name'@'your_user_ip' IDENTIFIED BY 'your_password';
GRANT SELECT, INSERT, UPDATE ON your_project_name.users TO 'your_user_name'@'your_user_ip';
GRANT SELECT ON your_project_name.achievements TO 'your_user_name'@'your_user_ip';
GRANT SELECT, INSERT, UPDATE ON your_project_name.user_achievements TO 'your_user_name'@'your_user_ip';