Debian 10.9.x编译安装MySQL8.0.x

在debian 10.9.x系统上编译安装mysql 8.0.x的详细步骤

准备工作请参考：https://www.php.cn/link/cdd2216bce00598e1d27af72cd761323

MySQL 8.0.x安装过程

1. 安装rpcsvc-proto:

   cd /usr/local/src
   xz -d rpcsvc-proto-1.4.2.tar.xz
   tar xvf rpcsvc-proto-1.4.2.tar
   cd rpcsvc-proto-1.4.2
   ./configure
   make
   make install

2. 安装cmake:

   cd /usr/local/src
   tar zxvf cmake-3.20.2.tar.gz
   cd cmake-3.20.2
   ./configure
   make
   make install

3. 安装MySQL:

   3.1 准备工作:

   

   码上飞

   码上飞（CodeFlying） 是一款AI自动化开发平台，通过自然语言描述即可自动生成完整应用程序。

   下载

   groupadd mysql
   useradd -g mysql mysql -s /bin/false
   mkdir -p /data/mysql
   chown -R mysql:mysql /data/mysql
   mkdir -p /usr/local/mysql
   cd /usr/local/src
   tar zxvf mysql-boost-8.0.25.tar.gz
   cd mysql-8.0.25

   3.2 编译安装MySQL (注意：此步骤需要较大的磁盘空间，建议根分区空间充足):

   cmake . \
       -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
       -DINSTALL_DATADIR=/data/mysql \
       -DMYSQL_USER=mysql \
       -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
       -DDEFAULT_CHARSET=utf8 \
       -DDEFAULT_COLLATION=utf8_general_ci \
       -DWITH_INNOBASE_STORAGE_ENGINE=1 \
       -DWITH_EMBEDDED_SERVER=1 \
       -DFORCE_INSOURCE_BUILD=1 \
       -DWITH_MYISAM_STORAGE_ENGINE=1 \
       -DENABLED_LOCAL_INFILE=1 \
       -DEXTRA_CHARSETS=all \
       -DDOWNLOAD_BOOST=1 \
       -DWITH_BOOST=/usr/local/src/mysql-8.0.25/boost \
       -DCMAKE_C_COMPILER=/usr/bin/gcc \
       -DCMAKE_CXX_COMPILER=/usr/bin/g++
   
   make
   make install

   3.3 初始化MySQL数据库并设置配置文件:

   rm -rf /etc/my.cnf /etc/mysql/my.cnf  # 删除现有配置文件 (如有)
   cd /usr/local/mysql
   ./bin/mysqld --user=mysql --initialize --basedir=/usr/local/mysql --datadir=/data/mysql # 初始化数据库，记录生成的root密码
   mkdir -p /usr/local/mysql/etc/
   nano /usr/local/mysql/etc/my.cnf # 创建并编辑配置文件 (内容如下，根据实际情况调整)
   
   [mysqld]
   port=3306
   tmpdir=/tmp
   datadir=/data/mysql
   socket=/tmp/mysql.sock
   user=mysql
   symbolic-links=0
   key_buffer_size=16M
   max_allowed_packet=128M
   default_authentication_plugin=mysql_native_password
   open_files_limit=60000
   explicit_defaults_for_timestamp
   server-id=1
   character-set-server=utf8
   federated
   max_connections=1000
   max_connect_errors=100000
   interactive_timeout=86400
   wait_timeout=86400
   sync_binlog=0
   back_log=100
   default-storage-engine=InnoDB
   log_slave_updates=1
   key_buffer_size=16M
   
   [mysqldump]
   quick
   
   [mysqld_safe]
   log-error=/var/log/mysqld.log
   pid-file=/var/run/mysqld/mysqld.pid
   
   [mysqld-8.0]
   sql_mode=TRADITIONAL
   
   [mysqladmin]
   force
   
   [client]
   password="your_password" # 替换为你的密码
   port=3306
   socket=/tmp/mysql.sock
   

   3.4 配置系统服务:

   mkdir -p /etc/rc.d/
   ln -s /etc/init.d /etc/rc.d/
   ln -s /usr/local/mysql/etc/my.cnf /etc/my.cnf
   cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
   chmod 755 /etc/init.d/mysqld
   apt-get remove insserv
   update-rc.d mysqld defaults 99
   nano /etc/rc.d/init.d/mysqld # 修改basedir和datadir路径
   systemctl daemon-reload
   service mysqld start
   systemctl restart mysqld.service

   3.5 设置环境变量:

   nano /etc/profile # 添加 export PATH=$PATH:/usr/local/mysql/bin
   source /etc/profile
   ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql
   ln -s /usr/local/mysql/include/mysql/* /usr/include/mysql/
   mkdir /var/lib/mysql
   ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

4. 修改root密码并创建用户和数据库:

   mysql -u root -p # 使用初始化生成的密码登录
   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_strong_password'; # 修改root密码
   FLUSH PRIVILEGES;
   CREATE DATABASE IF NOT EXISTS `www.osyunwei.com` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
   CREATE USER 'osyunwei.com'@'localhost' IDENTIFIED WITH mysql_native_password BY 'osyunwei';
   GRANT ALL PRIVILEGES ON `www.osyunwei.com`.* TO 'osyunwei.com'@'localhost';
   GRANT SUPER ON *.* TO 'osyunwei.com'@'localhost';
   FLUSH PRIVILEGES;
   exit
   service mysqld restart

记住将 your_password 和 your_strong_password 替换成你自己的强密码。 安装过程中请仔细检查每个步骤，并根据你的系统实际情况进行调整。 安装完成后，记得备份你的MySQL数据。