Mysql Decompression Version Configuration steps detailed tutorial _mysql

1. Mysql-5.7.14-winx64\bin Configuration to Path
2. Copy the My-default.ini under the decompression path and modify the name to My.ini
3. Add the following in My.ini

[Mysqld]
basedir=c:\\software\mysql\mysql-5.7.14-winx64
Datadir=c:\\software\mysql\mysql-5.7.14-winx64\data
port=3306

• Basedir: Is the above MySQL decompression path
• DataDir: Subsequent initialization data will be saved in the directory, the new data folder in the file directory
• Run the Windows command line as an administrator
• into MySQL's uncompressed bin directory
• Perform MySQL--initialize--user=mysql--console
• Run command: mysqld--install [install MySQL service]
• If---execution mysqld already exists--remove
• Reinstall the MySQL service and run the command mysqld--install
• Command line Input mysql-u root-p, error description: 1045 (28000)
• In the My.ini file, add Skip-grant-tables on the following line in [Mysqld]
• At this point, turn off the MySQL service and restart
• net stop MySQL
• net start MySQL
• Enter without entering a password
• Select MySQL database: Execute use MySQL
• Perform an update operation on table User: Update user set authentication_string = ' root ' where user= ' root '
• The operation was successful. Exit MySQL
• Restart the MySQL service

The above is a small set to introduce the MySQL release version of the configuration steps detailed tutorial, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!