Installation process:
1. Download 5.15.7, http://dev.mysql.com/downloads/, select Open Source Community Edition: MySQL Community Server (GPL)
2. I unzip it and put it under the E:\mysql\5.7.15\.
3. Add E:\mysql\5.7.15\bin to the system path
4. Install the MySQL service: mysqld--install
5. Edit the E:\mysql\5.7.15\my.ini file
# for advice The Change settings see# http: // dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html # * * * does not EDIT the this FILE. It " s a template which would be copied to the # default location during install, and would be replaced if you# *** upgrade to a newer version of Mysql. [Mysqld]basedir = E:/mysql/5.7 . 15 datadir = E:/mysql/dataport = 3306 sql_mode =no_engine_substitution,strict_trans_tables
6. Open the CMD Command window as an administrator
7. Initialize Mysql:mysqld--initialize
8. Start MySQL service: net start MySQL
====================================================================
Problems encountered:
Question 1:
E:\mysql\5.7. >3534 for more help. E:\mysql\5.7. the 3534 The service did not report any errors.
Question 2:
This error is not maintained and logged because the directory specified by DataDir in My.ini does not exist, and the path delimiter needs to be in the Linux format "/" instead of "\"
If MySQL cannot find the data directory, initialization will be an error:
E:\mysql\5.7. the\bin>mysqld--Initializemysqld:can'T Create directory'E:\myusql\data\'(Errcode:2-No such file or directory) .- the-16t07: the:Panax Notoginseng.476808Z0[Warning] TIMESTAMP withImplicitDEFAULT value isDeprecated. --explicit_defaults_for_timestamp server option (see documentation forMore details). .- the-16t07: the:Panax Notoginseng.476808Z0[Warning]'no_zero_date','no_zero_in_date'and'Error_for_division_by_zero'SQL modes should is used with strict mode. They'll be merged with strict modeincha future release. .- the-16t07: the:Panax Notoginseng.476808Z0[Warning]'No_auto_create_user'SQL mode is notSet. .- the-16t07: the:Panax Notoginseng.492808Z0[ERROR] Aborting
Problem 3:data The directory is not empty, and it also initializes with an error:
E:\mysql\5.7. the\bin>mysqld--Initialize .- the-16t07: -: -.306817Z0[Warning] TIMESTAMP withImplicitDEFAULT value isDeprecated. --explicit_defaults_for_timestamp server option (see documentation forMore details). .- the-16t07: -: -.306817Z0[Warning]'no_zero_date','no_zero_in_date'and'Error_for_division_by_zero'SQL modes should is used with strict mode. They'll be merged with strict modeincha future release. .- the-16t07: -: -.306817Z0[Warning]'No_auto_create_user'SQL mode is notSet. .- the-16t07: -: -.310106Z0[ERROR]--initialize specified but the data directory has filesinchit. Aborting. .- the-16t07: -: -.318664Z0[ERROR] Aborting
Windows 10 does not start the problem after MySQL installation