Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install mysql8.0.18 in the winx64 environment, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Create a my.ini file

[mysql] # set mysql client default character set default-character-set=utf8mb4 [mysqld] # set port 3306 port = 330 set mysql installation directory basedir=D:\\ Program Files\\ mysql-8.0.18# set mysql database data storage directory, MySQL 8 + does not need the following configuration, the system can generate its own Otherwise, there may be an error # datadir=H:\\ MyWork\\ mysql-8.0.11\ data# allows maximum number of connections the character set used by the max_connections=100# server defaults to the 8-bit encoded latin1 character set character-set-server=utf8mb4# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Note: the installation directory must be changed to the directory you want to install; the data storage directory, MySQL 8 + does not need to be set, the system generates its own

Run cmd as an administrator to enter the bin directory

Execute a command

Initialize the database mysqld-initialize-console

Get the password of the root account

2019-11-25T02:10:27.196981Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ZuN&Xe02&=b

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.