Linux 安装 MySQL8 ,MySQL版本 mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz

[root@localhost tmp]# 
[root@localhost tmp]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz
--2024-07-29 06:28:00--  https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz
Resolving dev.mysql.com (dev.mysql.com)... 104.85.26.254, 2600:1417:76:58b::2e31, 2600:1417:76:589::2e31
Connecting to dev.mysql.com (dev.mysql.com)|104.85.26.254|:443... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz [following]
--2024-07-29 06:28:02--  https://cdn.mysql.com//archives/mysql-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz
Resolving cdn.mysql.com (cdn.mysql.com)... 23.5.12.118, 2600:1417:76:580::1d68, 2600:1417:76:588::1d68
Connecting to cdn.mysql.com (cdn.mysql.com)|23.5.12.118|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 604856088 (577M) [text/plain]
Saving to: ‘mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz’

100%[=============================================================================================================================================================================>] 604,856,088 5.56MB/s   in 3m 59s 

2024-07-29 06:32:03 (2.41 MB/s) - ‘mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz’ saved [604856088/604856088]

[root@localhost tmp]# ll
total 590680
-rw-r--r-- 1 root root 604856088 Sep 14  2022 mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz
 

[root@localhost tmp]# tar -xvf mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz
mysql-8.0.31-linux-glibc2.12-x86_64/bin/
mysql-8.0.31-linux-glibc2.12-x86_64/bin/myisam_ftdump
mysql-8.0.31-linux-glibc2.12-x86_64/bin/myisamchk
mysql-8.0.31-linux-glibc2.12-x86_64/bin/myisamlog
mysql-8.0.31-linux-glibc2.12-x86_64/bin/myisampack
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_config_editor
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_migrate_keyring
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_secure_installation
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_upgrade
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqladmin
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlbinlog
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlcheck
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqldump
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlimport
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlpump
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlshow
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqlslap
mysql-8.0.31-linux-glibc2.12-x86_64/lib/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/plugin/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/plugin/authentication_fido_client.so
mysql-8.0.31-linux-glibc2.12-x86_64/lib/plugin/authentication_kerberos_client.so
mysql-8.0.31-linux-glibc2.12-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.31-linux-glibc2.12-x86_64/lib/plugin/authentication_oci_client.so
mysql-8.0.31-linux-glibc2.12-x86_64/bin/
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqld-debug
mysql-8.0.31-linux-glibc2.12-x86_64/bin/
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysql_config
mysql-8.0.31-linux-glibc2.12-x86_64/include/
mysql-8.0.31-linux-glibc2.12-x86_64/include/errmsg.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/field_types.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/my_command.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/my_compress.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/my_list.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql/
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql/client_plugin.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql_com.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql_time.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysql_version.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysqlx_ername.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysqlx_error.h
mysql-8.0.31-linux-glibc2.12-x86_64/include/mysqlx_version.h
mysql-8.0.31-linux-glibc2.12-x86_64/lib/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/libmysqlclient.a
mysql-8.0.31-linux-glibc2.12-x86_64/lib/libmysqlservices.a
mysql-8.0.31-linux-glibc2.12-x86_64/lib/pkgconfig/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.31-linux-glibc2.12-x86_64/share/
mysql-8.0.31-linux-glibc2.12-x86_64/share/aclocal/
mysql-8.0.31-linux-glibc2.12-x86_64/share/aclocal/mysql.m4
mysql-8.0.31-linux-glibc2.12-x86_64/docs/
mysql-8.0.31-linux-glibc2.12-x86_64/docs/ChangeLog
mysql-8.0.31-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.31-linux-glibc2.12-x86_64/docs/
mysql-8.0.31-linux-glibc2.12-x86_64/docs/INFO_BIN
mysql-8.0.31-linux-glibc2.12-x86_64/docs/INFO_SRC
mysql-8.0.31-linux-glibc2.12-x86_64/man/
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/comp_err.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/ibd2sdi.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/innochecksum.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/lz4_decompress.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/my_print_defaults.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/myisamchk.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/myisamlog.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/myisampack.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql.server.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_config.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqladmin.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlcheck.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlimport.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlman.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlpump.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlrouter.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlshow.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/mysqlslap.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/perror.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man1/zlib_decompress.1
mysql-8.0.31-linux-glibc2.12-x86_64/man/man8/
mysql-8.0.31-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-8.0.31-linux-glibc2.12-x86_64/LICENSE
mysql-8.0.31-linux-glibc2.12-x86_64/README
mysql-8.0.31-linux-glibc2.12-x86_64/bin/
mysql-8.0.31-linux-glibc2.12-x86_64/bin/ibd2sdi
mysql-8.0.31-linux-glibc2.12-x86_64/bin/innochecksum
mysql-8.0.31-linux-glibc2.12-x86_64/bin/lz4_decompress
mysql-8.0.31-linux-glibc2.12-x86_64/bin/my_print_defaults
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqld
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-8.0.31-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-8.0.31-linux-glibc2.12-x86_64/bin/perror
mysql-8.0.31-linux-glibc2.12-x86_64/bin/zlib_decompress
mysql-8.0.31-linux-glibc2.12-x86_64/lib/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.31-linux-glibc2.12-x86_64/lib/mecab/dic/ipadic_sjis/ma

### 如何在 Linux安装 MySQL 8.0.31 的特定版本 以下是针对 `mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz` 文件的安装方法: #### 准备工作 确保系统已满足基本依赖条件。可以运行以下命令来更新系统的软件包管理器并安装必要的工具: ```bash sudo yum update -y && sudo yum install wget tar gcc make cmake perl ncurses-devel bison-devel openssl-devel -y ``` #### 下载文件 如果尚未下载目标压缩包,则可以通过如下方式获取它: ```bash wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz ``` 此操作会将指定版本MySQL 压缩包保存到当前目录下[^1]。 #### 解压与移动位置 解压刚刚下载好的 `.tar.xz` 文件至 `/usr/local/mysql` 路径作为默认安装路径: ```bash tar xf mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz -C /usr/local/ mv /usr/local/mysql-8.0.31-linux-glibc2.12-x86_64 /usr/local/mysql ``` 上述步骤中的 `-C` 参数指定了提取的目标目录,而最后一步重命名是为了简化后续配置过程[^2]。 #### 创建用户组和服务账户 为了安全起见,应该创建一个新的专用服务账号用于运行数据库实例而不是 root 用户执行相关任务: ```bash groupadd mysql useradd -r -g mysql -s /bin/false mysql chown -R mysql:mysql /usr/local/mysql/ ``` #### 初始化数据目录 进入新部署完成后的二进制程序所在的位置,并初始化存储区域结构: ```bash cd /usr/local/mysql/bin ./mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/var/lib/mysql mkdir -p /var/lib/mysql chown -R mysql:mysql /var/lib/mysql ``` 这里需要注意的是参数选项解释: - `--initialize-insecure`: 不设置初始密码以便手动调整后再加强安全性; - `--user=mysql`: 明确指出由哪个具体身份启动进程; - `--basedir=...`: 设定基础安装地址; - `--datadir=...`: 自定义实际存放表记录物理磁盘上的地方. #### 配置环境变量 为了让 shell 更加便捷识别 mysqld 及其他关联指令,在全局范围内追加 PATH 设置项即可实现这一目的: 编辑 profile 或者 bashrc 文件加入下面这行文字之后重新加载生效或者直接 source 即可立即应用更改效果: ```bash echo 'export PATH=$PATH:/usr/local/mysql/bin' >> ~/.bash_profile source ~/.bash_profile ``` #### 启动服务 通过 systemd 来控制开机自启状态以及即时开启服务功能模块: ```bash cp support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld chkconfig --add mysqld service mysqld start ``` 至此整个流程结束,现在就可以正常连接测试验证成果啦! ```python import pymysql.cursors connection = pymysql.connect(host='localhost', user='root', password='', cursorclass=pymysql.cursors.DictCursor) try: with connection.cursor() as cursor: sql = "SELECT VERSION()" cursor.execute(sql) result = cursor.fetchone() finally: connection.close() print(result['VERSION()']) ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值