mysql8.0 xp支持吗_MySql 8.0.11-Winxp64(免安装版)配置教程

最新推荐文章于 2021-02-07 05:45:34 发布

打呼少年

最新推荐文章于 2021-02-07 05:45:34 发布

阅读量294

点赞数

文章标签： mysql8.0 xp支持吗

本文链接：https://blog.csdn.net/weixin_42358733/article/details/113260428

版权

本文介绍了如何在Windows XP上安装MySQL 8.0.11的免安装版，包括解压文件、创建my.ini配置文件、初始化数据库以及获取root用户的初始密码。详细步骤包括设置数据目录、端口、字符集等，并提醒用户注意记录初始化过程中显示的临时密码。

摘要由CSDN通过智能技术生成

1. 解压zip包到安装目录

首先，将mysql-8.0.11-winx64.zip 解压缩到安装D:/mysql-8.0.11-winx64 目录下，

2.配置文件

在安装根目录下添加 my.ini

基本配置文件(my)

[mysqld]

basedir = D:mysql-8.0.11-winx64

datadir = D:mysql-8.0.11-winx64data

port = 3306

lower_case_table_names = 2

default_authentication_plugin=mysql_native_password

参考基本配置：

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = D:ProgramMySQL

datadir = D:DBsMySQL

port = 3306

# server_id = .....

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

character-set-server = utf8mb4

performance_schema_max_table_instances = 600

table_definition_cache = 400

table_open_cache = 256

[mysql]

default-character-set = utf8mb4

[client]

default-character-set = utf8mb4

3.初始化数据库

在MySQL安装目录的 bin 目录下执行命令：

mysqld --initialize --console

执行完成后，会打印 root 用户的初始默认密码，比如：

2018-04-20T02:35:01.507037Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2018-04-20T02:35:01.507640Z 0 [System] [MY-013169] [Server] D:ProgramMySQL8binmysqld.exe (mysqld 8.0.11) initializing of server in progress as process 11064

2018-04-20T02:35:01.508173Z 0 [ERROR] [MY-010340] [Server] Error message file 'D:ProgramMySQLshareenglisherrmsg.sys' had only 1090 error messages, but it should contain at least 4512 error messages. Check that the above file is the right version for this program!

2018-04-20T02:35:05.464644Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: APWCY5ws&hjQ

2018-04-20T02:35:07.017280Z 0 [System] [MY-013170] [Server] D:ProgramMySQL8binmysqld.exe (mysqld 8.0.11) initializing of server has completed

其中，第4行的“APWCY5ws&hjQ”就是初始密码，在没有更改密码前，需要记住这个密码，后续登录需要用到。

如果没记住，那也没事，删掉初始化的 datadir 目录，再执行一遍初始化命令，又会重新生成的。当然，也可以使用安全工具，强制改密码，用什么方法，自己随意。