Home > database >  MySQL 8.0.18 can't install, a great god guide genuflect is begged
MySQL 8.0.18 can't install, a great god guide genuflect is begged

Time:10-27

Steps refer to the online a blog, https://www.runoob.com/mysql/mysql-install.html
In the website to download the Windows version MYSQL version 8.0.18

Decompression to disk C \ web file

The new document, copy and paste the code blog, change file called my. Ini

Use open win + x administrator privileges CMD

Please input the CD C: \ web \ mysql - 8.0.18 \ bin

Mysqld, initialize the console

Computer display as follows:

Microsoft Windows version 10.0.14393 []
(c) 2016 Microsoft Corporation, all rights reserved.

C: \ WINDOWS \ system32 & gt; CD C: \ web \ mysql - 8.0.18 \ bin

C: \ web \ mysql - 8.0.18 \ bin> Mysqld -- -- the initialize the console
The 2019-12-23 T03: :. 156170 z 0 [System] [MY - 010116] [Server] C: \ web \ mysql - 8.0.18 \ bin \ mysqld exe (mysqld 8.0.18) starting as process 3768
The 2019-12-23 T03: :. 156423 z 0 [ERROR] [MY - 010338] (Server) Can 't find the ERROR - the message file' C: \ web \ mysql - 8.0.11 \ share \ errmsg sys'. Check the ERROR - the message file location and 'lc - messages - dir' configuration directive.
The 2019-12-23 T03: :. 157606 z 0 [Warning] [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. Both Please consider using UTF8MB4 in order to be unambiguous.
2019-12-23 T03: :. 160402 z 0 [Warning] [MY - 010091] (Server) Can 't create the test file C: \ web \ mysql - 8.0.11 \ data \ mysqld_tmp_file_case_insensitive_test lower - test
2019-12-23 T03: :. 160891 z 0 [Warning] [MY - 010091] (Server) Can 't create the test file C: \ web \ mysql - 8.0.11 \ data \ mysqld_tmp_file_case_insensitive_test lower - test
The 2019-12-23 T03: :. 161907 z 0 [ERROR] [MY - 013276]/Server Failed to set datadir to 'C: \ web \ mysql - 8.0.11 \ data \' (OS errno: 2 - No to the file or directory)
The 2019-12-23 T03: :. 165220 z 0 [ERROR] [MY - 010119] [Server] Aborting
The 2019-12-23 T03: :. 165607 z 0 [System] [MY - 010910] [Server] C: \ web \ mysql - 8.0.18 \ bin \ mysqld exe: Shutdown complete (mysqld 8.0.18) mysql Community Server - the GPL.

C: \ web \ mysql - 8.0.18 \ bin> Mysqld install
Service successfully installed.

C: \ web \ mysql - 8.0.18 \ bin> Net start mysql
The MySQL service is starting.
The MySQL service cannot be started,

Service report no errors,

Please type the NET HELPMSG 3534 for more help,


C: \ web \ mysql - 8.0.18 \ bin> Net helpmsg 3534

Service report no errors,


C: \ web \ mysql - 8.0.18 \ bin> NET HELPMSG 2524

System can't find the message in the message file for NETMSG number 0 x9dc message text,


C: \ web \ mysql - 8.0.18 \ bin> NET HELPMSG 3534

Service report no errors,


C: \ web \ mysql - 8.0.18 \ bin> Net start mysql
The MySQL service is starting.
The MySQL service cannot be started,

Service report no errors,

Please type the NET HELPMSG 3534 for more help,


C: \ web \ mysql - 8.0.18 \ bin> NET HELPMSG 3534

Service report no errors,


C: \ web \ mysql - 8.0.18 \ bin>

Excuse me why cannot successfully installed, thanks

CodePudding user response:

Look at the error
C: \ web \ mysql - 8.0.11 \ data \ '(OS errno: 2 - No to the file or directory)

You started out as a CD C: \ web \ mysql - 8.0.18 \ bin
Two different directory

My. Ini datadir modification

CodePudding user response:

Enter the password, the display can't connect to the local server
Don't know what's the meaning of
  • Related