實(shí)驗(yàn)環(huán)境openEuler Linux 虛擬機(jī)、MySQL 8.0.45、Python3.11.9、騰訊云 TokenHub 大模型 API實(shí)驗(yàn)?zāi)繕?biāo)獨(dú)立完成 Linux 服務(wù)器、MySQL 數(shù)據(jù)庫(kù)、Python 運(yùn)行環(huán)境全套部署實(shí)現(xiàn)自然語(yǔ)言自動(dòng)生成只讀 MySQL 查詢、自動(dòng)執(zhí)行并 AI 解讀業(yè)務(wù)數(shù)據(jù)實(shí)現(xiàn) SQL 執(zhí)行計(jì)劃解析、自動(dòng)輸出索引優(yōu)化與 SQL 改寫(xiě)方案完成命令行終端 Streamlit Web 可視化雙端交互完成安全加固、功能全場(chǎng)景測(cè)試、異常容錯(cuò)驗(yàn)證。成果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-hostmirrors.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 --usermysql --basedir/usr/local/mysql --datadir/usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe --usermysql /usr/local/mysql/bin/mysql -u root -p # mysql內(nèi)執(zhí)行 alter user rootlocalhost 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 下單時(shí)間 ) ENGINEInnoDB COMMENT電商訂單業(yè)務(wù)表; 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