资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

windows10+mysql8.0.11zip安装教程详解-创新互联

准备:

创新互联于2013年成立,先为高昌等服务建站,高昌等地企业,进行企业商务咨询服务。为高昌企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

MySQL8.0 Windows zip包下载地址:https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip

环境:Windows 10

一、安装

1. 解压zip包到安装目录

我的安装目录是D:\Program Files\mysql-8.0.11-winx64

2.配置文件

windows系统中配置文件默认是安装目录下的 my.ini 文件,部分配置需要在初始安装时配置,大部分也可以在安装完成后进行更改,不知道别人是什么情况,我的是该文件目录下不存在my.ini文件,所以我新建了该文件,如下

写入基本配置如下:

[mysqld]
default_authentication_plugin=mysql_native_password
# 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:\Program Files\mysql-8.0.11-winx64
datadir=D:\Program Files\mysql-8.0.11-winx64\data(这两行是主要修改的内容,会自动生成data文件夹,其他直接粘贴即可)
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

网页题目:windows10+mysql8.0.11zip安装教程详解-创新互联
转载源于:http://cdkjz.cn/article/cdehjg.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220