Shulou(Shulou.com)06/01 Report--

This article shares the installation and configuration tutorial of mysql 8.0.13 for your reference. The details are as follows.

download

Download address

Decompression

There is no my.ini file (3308 of my port setting) after decompression. I added it in the screenshot.

[client] port = 3308default-character-set = utf8 [mysqld] port = 3308character_set_server = utf8 basedir=D:\ MySQL\ mysql-8.0.13-winx64datadir=D:\ MySQL\ mysql-8.0.13-winx64\ data group_concat_max_len=20000 [WinMySQLAdmin] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe

Administrator command line

Execute the command in the bin directory of the MySQL installation directory:

Mysqld-initialize-console

The following results are obtained.

D:\ MySQL\ mysql-8.0.13-winx64\ bin > mysqld-- initialize-- console2018-10-24T05:32:45.732454Z 0 [System] [MY-013169] [Server] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 430802018-10-24T05:32:45.870611Z 0 [MY-013242] [Server]-- character-set-server: 'utf8' is currently an alias for the character set UTF8MB3 But will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.2018-10-24T05:33:14.879343Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: MMQP.YfCy5XY2018-10-24T05:33:37.812581Z 0 [System] [MY-013170] [Server] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server has completed D:\ MySQL\ mysql-8.0.13-winx64\ bin >

When I saw a warning, I checked mysql and recommended to use utf8mb4.

Modify the my.ini file

[client] port = 3308default-character-set = UTF8MB4 [mysqld] port = 3308character-set-server = UTF8MB4 basedir=D:\ MySQL\ mysql-8.0.13-winx64datadir=D:\ MySQL\ mysql-8.0.13-winx64\ data group_concat_max_len=20000 [WinMySQLAdmin] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe

The warning is gone.

D:\ MySQL\ mysql-8.0.13-winx64\ bin > mysqld-- initialize-console2018-10-24T06:06:51.100372Z 0 [System] [MY-013169] [Server] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 478042018-10-24T06:07:18.372699Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nj > uUJkpH4/I2018- 10-24T06:07:36.024435Z 0 [System] [MY-013170] [Server] D:\ MySQL\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server has completed D:\ MySQL\ mysql-8.0.13-winx64\ bin >

The default password is printed on it: nj > uUJkpH4/I

Installation service

Mysqld-install MySQL8.0

Because this is the second mysql on the computer, the service name has been changed to MySQL8.0.

Start the service

Net start MySQL8.0

Change the initial password

Execute after logging in to mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456'

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.