MySQL for Windows Zip Edition installation

1. Extract the Mysql_5.6.24_winx64.zip to the folder

2. Increase environment variables

3. Modify the MySQL configuration file

Rename the My-default.ini copy of the MySQL root directory to My.ini. modifying parameter values

# These is commonly set, remove the # and set as required.
basedir = D:\Program files\mysql\mysql-5.6.24
DataDir = D:\Program Files\mysql\mysql-5.6.24\data
# port = .....
# server_id = ...

4. Registration Service

Use CMD with administrator privileges or Windows PowerShell to enter D:\Program Files\mysql\mysql-5.6.24\bin

Perform PS D:\Program files\mysql\mysql-5.6.24\bin> ./mysqld-install

Return: Service successfully installed.

5. Start the service

PS D:\Program files\mysql\mysql-5.6.24\bin> net start MySQL
The MySQL service is starting.
The MySQL service has started successfully.

6. Modify the default password

such as: Mysqladmin.exe-u user name-p password New password

PS D:\Program files\mysql\mysql-5.6.24\bin> \mysqladmin.exe-uroot-p Password [email protected]
Enter Password: (type old password)

MySQL for Windows Zip Edition installation