当前位置:网站首页>Mysql8 installation
Mysql8 installation
2022-04-23 12:53:00 【Rain fish in summer】
mysql8 install
mysql8 install
my.ini
[mysqld]
# Set up 3306 port
port=3306
# Set up mysql Installation directory
basedir=D:\database\mysql-8.0.28-winx64
# Set up mysql Database data storage directory
datadir=D:\database\mysql-8.0.28-winx64\Data
# Maximum connections allowed
max_connections=2000
# Number of connection failures allowed .
max_connect_errors=10
# The character set used by the server defaults to utf8mb4
character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table
default-storage-engine=INNODB
# By default “mysql_native_password” Plug in authentication
#mysql_native_password
default_authentication_plugin=mysql_native_password
sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
[mysql]
# Set up mysql Client default character set
default-character-set=utf8mb4
[client]
# Set up mysql The default port when the client connects to the server
port=3306
default-character-set=utf8mb4
Installation command
mysqld --initialize --console
mysqld --install
Screenshot

版权声明
本文为[Rain fish in summer]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231252487256.html
边栏推荐
- BUUCTF WEB [BUUCTF 2018]Online Tool
- leetcode:437. 路径总和 III【dfs 选还是不选?】
- [wechat applet] Z-index is invalid
- 【unity笔记】L4Unity中的基础光照
- 洛谷P3236 [HNOI2014]画框 题解
- If you were a golang interviewer, what questions would you ask?
- 软件测试周刊(第68期):解决棘手问题的最上乘方法是:静观其变,顺水推舟。
- 航芯技术分享 | ACM32 MCU安全特性概述
- Synchronously update the newly added and edited data to the list
- Uni app native app cloud packaging integrated Aurora push (jg-jpush) detailed tutorial
猜你喜欢

航芯技术分享 | ACM32 MCU安全特性概述

4.DRF 权限&访问频率&过滤&排序

网站首页文件被攻击篡改的形式有哪些

Unlock openharmony technology day! The annual event is about to open!

教你快速开发一个 狼人杀微信小程序(附源码)

如何实现点击一下物体播放一次动画

Kubernets Getting started tutoriel

How to prevent the website from being hacked and tampered with

Image attribute of input: type attribute of fashion cloud learning -h5

SSM框架系列——数据源配置day2-1
随机推荐
Dialogue with Bruce, author of PostgreSQL: "changing careers" is to better move forward
Unlock openharmony technology day! The annual event is about to open!
基于卷积神经网络的遥感影像分类识别系统
CVPR 2022 & ntire 2022 | the first transformer for hyperspectral image reconstruction
解决disagrees about version of symbol device_create
数据库中的日期时间类型
8 websites that should be known for product development to enhance work experience
flask项目跨域拦截处理以及dbm数据库学习【包头文创网站开发】
RT-thread中关键词解释及部分API
Softbank vision fund entered the Web3 security industry and led a new round of investment of US $60 million in certik
Deploying MySQL in cloud native kubesphere
What are the forms of attack and tampering on the home page of the website
Kubernetes 入门教程
0基础可以考CPDA数据分析师证书吗
Image attribute of input: type attribute of fashion cloud learning -h5
31. 下一个排列
Kubernetes 入門教程
Remote access to raspberry pie at home (Part 1)
BaseRecyclerViewAdapterHelper 实现下拉刷新和上拉加载
Use source insight to view and edit source code