Windows 2012 install MySQL 5.7.22 Enterprise Edition

I. Environment description Operating system: Windows 2012 database: MySQL 5.7.12 Enterprise Edition II, Operation Step 1, planning MySQL installation files are stored in D:\mysql, the data directory is E:MYSQLDATA2, the configuration file location is d:\mysql\ My.ini content is as follows: [mysqld] port = 3306 basedir= d:\mysqldatadir= e:\mysqldatamax_connections=500 Character-set-server=utf8 Default-storage-engine=innodb sql_mode=no_engine_substitution,strict_trans_tables [MySQL] default-character-set= UTF83, installation service C:\USERS\ADMIN>D:D:\>CD Mysql\bind:\mysql\bin>.\mysqld-install 4, initialize Mysql.\mysqld-- Initialize-insecure--user=mysql5, start service d:\mysql\bin>net start Mysqlmysql service is starting. The MySQL service has started successfully. 6, Login database D:\mysql\bin>mysql-uroot-penter password:welcome to the MySQL monitor. Commands End With; or \g.your MySQL connection ID is 2Server version:5.7.22 mysql Community Server (GPL) Copyright (c) #, 2018, Oracle and /or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names trademarks of their respectiveowners. Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current INput statement.mysql>7, change password use mysql;update mysql.user set Authentication_string=password (' qwe12345 ') where user= ' Root ' and Host = ' localhost '; flush privileges;8, Shutdown service d:\mysql\bin>net Stop Mysqlmysql service is stopping. The MySQL service has stopped successfully.

Windows 2012 install MySQL 5.7.22 Enterprise Edition