项目实施环境搭建系统搭建及初始化关闭selinx[rootlocalhost ~]# systemctl disable --now firewalld [rootlocalhost ~]# systemctl status firewalld更换时间同步服务器[rootserver ~]# date -s 2026-7-28 18:20:55安装依赖[rootserver ~]# 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源码编译安装Python3.11.9进入源码存放目录[rootserver ~]# cd /usr/local/src解压[rootserver src]# tar -zxvf Python-3.11.9.tgz [rootserver src]# cd Python-3.11.9编译配置[rootserver Python-3.11.9]# ./configure --prefix/usr/local/python3.11 --enable-shared多核编译安装[rootserver Python-3.11.9]# make make install [rootserver Python-3.11.9]# echo $(nproc) [rootserver Python-3.11.9]# make -j2配置动态链接库解决libpython缺失报错[rootserver Python-3.11.9]# echo /usr/local/python3.11/lib /etc/ld.so.conf.d/python311.conf [rootserver Python-3.11.9]# ldconfig --- 生效建立全局软链接不覆盖系统自带Python3先查看当前版本建立软连接[rootserver Python-3.11.9]# ln -s /usr/local/python3.11/bin/python3.11 /usr/local/bin/python3 [rootserver Python-3.11.9]# ln -s /usr/local/python3.11/bin/pip3.11 /usr/local/bin/pip3重启解释器[rootserver Python-3.11.9]# bash验证安装[rootserver Python-3.11.9]# python3 -V [rootserver Python-3.11.9]# pip3 -V校验SSL模块AI接口必备[rootserver Python-3.11.9]# python3 -c import ssl; print(ssl.OPENSSL_VERSION)配置国内pip源及安装项目依赖建立文件夹[rootserver ~]# mkdir .pip安装python及ai所需依赖[rootserver ~]# pip3 install --upgrade pip [rootserver ~]# pip3 install pymysql python-dotenv tabulate langchain langchain-openai脚本开发阶段新建目录及脚本编写环境变量脚本evn[rootserver mysql_ai_tools]# vim /opt/mysql_ai_tools/.env编写脚本[rootserver ~]# chmod 600 /opt/mysql_ai_tools/.env编写数据库连接脚本[rootserver ~]# vim /opt/mysql_ai_tools/mysql_client.py编写sql转换脚本[rootserver ~]# vim /opt/mysql_ai_tools/prompts.py编写程序入口脚本[rootserver ~]# vim /opt/mysql_ai_tools/main.py测试[rootserver ~]# python3 /opt/mysql_ai_tools/main.py安装 Python 依赖[rootserver ~]# /usr/local/python3.11/bin/pip3 install langchain-openai streamlit创建 Streamlit 可视化入口 web_main.py[rootserver ~]# vim /opt/mysql_ai_tools/web_main.py创建 systemd 后台常驻服务[rootserver ~]# vim /etc/systemd/system/mysql-ai-web.service启动服务[rootserver ~]# systemctl daemon-reload [rootserver ~]# systemctl enable --now mysql-ai-web
项目实施环境搭建系统搭建及初始化关闭selinx[rootlocalhost ~]# systemctl disable --now firewalld [rootlocalhost ~]# systemctl status firewalld更换时间同步服务器[rootserver ~]# date -s 2026-7-28 18:20:55安装依赖[rootserver ~]# 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源码编译安装Python3.11.9进入源码存放目录[rootserver ~]# cd /usr/local/src解压[rootserver src]# tar -zxvf Python-3.11.9.tgz [rootserver src]# cd Python-3.11.9编译配置[rootserver Python-3.11.9]# ./configure --prefix/usr/local/python3.11 --enable-shared多核编译安装[rootserver Python-3.11.9]# make make install [rootserver Python-3.11.9]# echo $(nproc) [rootserver Python-3.11.9]# make -j2配置动态链接库解决libpython缺失报错[rootserver Python-3.11.9]# echo /usr/local/python3.11/lib /etc/ld.so.conf.d/python311.conf [rootserver Python-3.11.9]# ldconfig --- 生效建立全局软链接不覆盖系统自带Python3先查看当前版本建立软连接[rootserver Python-3.11.9]# ln -s /usr/local/python3.11/bin/python3.11 /usr/local/bin/python3 [rootserver Python-3.11.9]# ln -s /usr/local/python3.11/bin/pip3.11 /usr/local/bin/pip3重启解释器[rootserver Python-3.11.9]# bash验证安装[rootserver Python-3.11.9]# python3 -V [rootserver Python-3.11.9]# pip3 -V校验SSL模块AI接口必备[rootserver Python-3.11.9]# python3 -c import ssl; print(ssl.OPENSSL_VERSION)配置国内pip源及安装项目依赖建立文件夹[rootserver ~]# mkdir .pip安装python及ai所需依赖[rootserver ~]# pip3 install --upgrade pip [rootserver ~]# pip3 install pymysql python-dotenv tabulate langchain langchain-openai脚本开发阶段新建目录及脚本编写环境变量脚本evn[rootserver mysql_ai_tools]# vim /opt/mysql_ai_tools/.env编写脚本[rootserver ~]# chmod 600 /opt/mysql_ai_tools/.env编写数据库连接脚本[rootserver ~]# vim /opt/mysql_ai_tools/mysql_client.py编写sql转换脚本[rootserver ~]# vim /opt/mysql_ai_tools/prompts.py编写程序入口脚本[rootserver ~]# vim /opt/mysql_ai_tools/main.py测试[rootserver ~]# python3 /opt/mysql_ai_tools/main.py安装 Python 依赖[rootserver ~]# /usr/local/python3.11/bin/pip3 install langchain-openai streamlit创建 Streamlit 可视化入口 web_main.py[rootserver ~]# vim /opt/mysql_ai_tools/web_main.py创建 systemd 后台常驻服务[rootserver ~]# vim /etc/systemd/system/mysql-ai-web.service启动服务[rootserver ~]# systemctl daemon-reload [rootserver ~]# systemctl enable --now mysql-ai-web
