sudo apt install -y ubuntu-desktop

sudo apt install -y chromium-browser

wget https://www.c-nergy.be/downloads/xRDP/xrdp-installer-1.4.8.zip
unzip xrdp-installer-1.4.8.zip
chmod +x xrdp-installer-1.4.8.sh
bash xrdp-installer-1.4.8.sh

sudo apt-get install -y language-pack-zh-hans
sudo update-locale LANG=zh_CN.UTF-8
#sudo reboot #重启生效

#!/usr/bin/env bash

# 定义密码
ROOT_PASSWORD="123456"
CHIEBOT_PASSWORD="123456"


# 卸载原有mysql
# 停止 MySQL 服务
echo "正在停止 MySQL 服务..."
sudo systemctl stop mysql
# 卸载 MySQL 服务器和客户端
echo "正在卸载 MySQL..."
sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
# 清除所有 MySQL 目录（包括数据库）
echo "正在删除 MySQL 数据目录..."
sudo rm -rf /etc/mysql /var/lib/mysql
# 清除残留的包和配置
echo "正在清除残留的包和配置..."
sudo apt-get autoremove -y
sudo apt-get autoclean
echo "MySQL 已经被完全卸载。"


# 安装 MySQL（如果尚未安装）
sudo apt update
sudo apt install mysql-server -y

# 启动 MySQL 服务
sudo systemctl start mysql

# 设置 MySQL 服务开机自启
sudo systemctl enable mysql

# 修改 MySQL 配置以允许远程连接
sudo sed -i 's/bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf

# 重启 MySQL 服务以应用配置更改
sudo systemctl restart mysql


# sudo mysql -u root -p$ROOT_PASSWORD -e "SET GLOBAL validate_password.special_char_count = 0;"
# sudo mysql -u root -p$ROOT_PASSWORD -e "SET GLOBAL validate_password.mixed_case_count = 0;"
# sudo mysql -u root -p$ROOT_PASSWORD -e "SET GLOBAL validate_password.check_user_name = 0;"

# # 设置 root 用户密码
sudo mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$ROOT_PASSWORD';"
sudo mysql -u root -e "FLUSH PRIVILEGES;"

# 创建 root 用户的远程访问账户
sudo mysql -u root -e "CREATE USER 'root'@'%' IDENTIFIED BY '$ROOT_PASSWORD';"
sudo mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';"
sudo mysql -u root -e "FLUSH PRIVILEGES;"

# 允许防火墙通过 MySQL，默认端口是 3306（如果防火墙开启的话）
sudo ufw allow 3306

# 新增 chiebot 用户，并设置密码和远程访问权限
sudo mysql -u root -e "CREATE USER 'chiebot'@'%' IDENTIFIED BY '$CHIEBOT_PASSWORD';"
sudo mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'chiebot'@'%' WITH GRANT OPTION;"
sudo mysql -u root -e "FLUSH PRIVILEGES;"

# 创建 chiebot_cv 数据库
sudo mysql -u root -e "CREATE DATABASE chiebot_cv;"

# 授予 chiebot 用户对 chiebot_cv 数据库的所有权限
sudo mysql -u root -e "GRANT ALL PRIVILEGES ON chiebot_cv.* TO 'chiebot'@'%';"
sudo mysql -u root -e "FLUSH PRIVILEGES;"

# 从 chiebot_cv_backup.sql 导入数据到 chiebot_cv 数据库
echo 'Importing data to chiebot_cv'
# 确保 chiebot_cv_backup.sql 文件在当前目录下
mysql -u chiebot -p$CHIEBOT_PASSWORD chiebot_cv < chiebot_cv_backup.sql

# 重启 MySQL 服务
sudo systemctl restart mysql

echo "MySQL 设置完成"

sudo apt-get update -y
sudo apt-get -y install \
    build-essential \
    libfontconfig1 \
    mesa-common-dev \
    libglu1-mesa-dev \
    python3 \
    python3-pip \
    qtcreator

sudo apt-get install -y qtbase5-dev qtchooser qt5-qmake qtbase5-dev-tools
sudo apt-get install -y qt5*
sudo apt-get install -y libqt5sql5-mysql