当前位置:网站首页>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
边栏推荐
- Uni app native app local packaging integrated Aurora push (jg-jpush) detailed tutorial
- [Blue Bridge Cup] April 17 provincial competition brushing training (the first three questions)
- 4. DRF permission & access frequency & filtering & sorting
- 云原生KubeSphere部署Mysql
- CGC: contractual graph clustering for community detection and tracking
- Synchronously update the newly added and edited data to the list
- unity常见的问题(一)
- Try the server for one month for free, and attach the tutorial
- Image attribute of input: type attribute of fashion cloud learning -h5
- The continuous construction of the Internet industry platform is not only able to collect traffic
猜你喜欢
Everything can be expected in the future | one 2022 campus recruitment officially opened
bert-base-chinese下载(智取)
进程虚拟地址空间区域划分
SSM framework series - data source configuration day2-1
[Blue Bridge Cup] April 17 provincial competition brushing training (the first three questions)
NPDP | how can product managers not be excluded by programmers?
How to prevent the website from being hacked and tampered with
31. Next arrangement
【蓝桥杯】4月17日省赛刷题训练(前3道题)
XinChaCha Trust SSL Organization Validated
随机推荐
软件测试周刊(第68期):解决棘手问题的最上乘方法是:静观其变,顺水推舟。
Use source insight to view and edit source code
【蓝桥杯】4月17日省赛刷题训练(前3道题)
标签与路径
Resolve disagrees about version of symbol device_ create
解决disagrees about version of symbol device_create
No idle servers? Import OVF image to quickly experience smartx super fusion community version
Web17 -- use of El and JSTL
Kubernetes 入门教程
[unity note] basic lighting in l4unity
Software testing weekly (issue 68): the best way to solve difficult problems is to wait and see the changes and push the boat with the current.
ZigBee CC2530 minimum system and register configuration (1)
box-sizing
Redis deployment of cloud native kubesphere
Buuctf Web [bjdctf2020] zjctf, but so
Calculate the past date and days online, and calculate the number of live days
MySQL function - recursive function
4. DRF permission & access frequency & filtering & sorting
SSL certificate refund instructions
Get the punch in record of nailing attendance machine