64-bit win10 system installation Green Edition mysql-5.7.16-winx64 tutorial, mysql Green Edition download 64-bit
This article mainly introduces the 64-bit win10 system installation of Green Edition mysql-5.7.16-winx64 method, the specific content is as follows:
1. DownloadMySQL Community Server
Address: http://dev.mysql.com/downloads/mysql/
Select Windows (x86, 64-bit) and ZIP Archive for download.
2. decompress the MySQL installation package to the specified directory., My directory is D: \ Program Files \ MySql \ mysql-5.7.16-winx64, and copy a my-default.ini file for backup.
3. Modify the my-default.ini File
Basedir = D: \ Program Files \ MySql \ mysql-5.7.16-winx64
Datadir = D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ data
Port = 3306
Note: remove the source file #
4. Add Environment Variables
New system variable MYSQL_HOME, variable value: D: \ Program Files \ MySql \ mysql-5.7.16-winx64
Modify the system variable Path and add % MYSQL_HOME % \ bin;
Note: variable values should be separated by commas (,).
5. Register windows Services
Open cmd with administrator permissions, enter the D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ bin directory,
Enter the service installation command: mysqld install MySQL -- defaults-file = "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ my-default.ini"
View the ImagePath value in the registry, my is "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ bin \ mysqld" -- defaults-file = "D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ my-default.ini "MySQL, which contains mysqld, will not be modified.
Registry location: \ HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MySQL
Execute mysqld -- initialize for initialization (generate data directory)
Execute net start MySQL
6. Modify the Default root Password
Find the initial password for MySQL, open the file D: \ Program Files \ MySql \ mysql-5.7.16-winx64 \ data under the directory suffix err, my DESKTOP-KCIHHJT.err
Search for the password keyword. My information is: A temporary password is generated for root @ localhost: = 2 v & I * 7Nab0r
The generated initial password is = 2 v & I * 7Nab0r
Run mysql-uroot-p
Enter the above initial password to access MySQL.
Execute set password = PASSWORD ('20140901 ');
Change Password to 123456
Use exit to exit MySQL, and then you can log on with the new password.
The above is a small series to introduce you to the 64-bit win10 system installation Green Edition mysql-5.7.16-winx64 tutorial, hope to help everyone, if you have any questions please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!