实验环境：

openEuler Linux 虚拟机、MySQL 8.0.45、Python3.11.9、腾讯云 TokenHub 大模型 API

实验目标：

独立完成 Linux 服务器、MySQL 数据库、Python 运行环境全套部署；

实现自然语言自动生成只读 MySQL 查询、自动执行并 AI 解读业务数据；

实现 SQL 执行计划解析、自动输出索引优化与 SQL 改写方案；

完成命令行终端 + Streamlit Web 可视化双端交互；

完成安全加固、功能全场景测试、异常容错验证。

成果：

sed -i '7s/enforcing/disabled/' /etc/selinux/config
systemctl disable --now firewalld
systemctl status firewalld

hostnamectl set-hostname server
bash

dnf install -y gcc gcc-c++ make cmake zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel libffi-devel tk-devel wget tar vim tree net-tools openssh-server

cd /usr/local/src
tar -zxvf Python-3.11.9.tgz
cd Python-3.11.9
./configure --prefix=/usr/local/python3.11 --enable-shared
make -j$(nproc) && make install

echo "/usr/local/python3.11/lib" > /etc/ld.so.conf.d/python311.conf
ldconfig

ln -s /usr/local/python3.11/bin/python3.11 /usr/local/bin/python3
ln -s /usr/local/python3.11/bin/pip3.11 /usr/local/bin/pip3
bash

python3 -V
pip3 -V
python3 -c "import ssl; print(ssl.OPENSSL_VERSION)"

mkdir ~/.pip
vim ~/.pip/pip.conf
[global]
index-url = http://mirrors.aliyun.com/pypi/simple/
[install]
trusted-host=mirrors.aliyun.com

pip3 install --upgrade pip
pip3 install pymysql python-dotenv tabulate langchain langchain-openai

groupadd mysql
useradd -r -g mysql -s /sbin/nologin mysql
mkdir /usr/local/mysql/data
chmod -R 750 data
chown -R mysql:mysql /usr/local/mysql

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

/usr/local/mysql/bin/mysqld_safe --user=mysql &
/usr/local/mysql/bin/mysql -u root -p
# mysql内执行
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
flush privileges;
exit

systemctl daemon-reload
systemctl enable --now mysqld.service
systemctl is-active mysqld

create database testdb;
use testdb;
create table order_info(
id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '订单ID',
user_id INT COMMENT '用户ID',
order_name VARCHAR(200) COMMENT '商品名称',
pay_amount DECIMAL(10,2) COMMENT '支付金额',
create_time DATETIME COMMENT '下单时间'
) ENGINE=InnoDB COMMENT='电商订单业务表';

mkdir -p /opt/mysql_ai_tools
cd /opt/mysql_ai_tools
touch main.py mysql_client.py prompts.py web_main.py .env

chmod 600 /opt/mysql_ai_tools/.env

/usr/local/python3.11/bin/pip3 install streamlit sqlparse

systemctl daemon-reload
systemctl enable --now mysql-ai-web
systemctl status mysql-ai-web