Unzip the downloaded compressed package
Copy a My-default.ini change name to My.ini as MySQL configuration file
Open My.ini Modify configuration file
The default original file is
# for advice The change settings see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * * * does not EDIT the this FILE. It's a template which'll be copied to the# * * * * default location during install,and would be replaced if you# * * * * Upgrade to a newer version of MySQL.[mysqld]# Remove Leading # and set to the amount of RAM for the most important data# caches in MySQL. Start at70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size=128m# Remove Leading # to turn on a very important data integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set,Remove the # and set as required.# Basedir=.... # datadir=..... # Port=.... # server_id=... # Remove leading # To set options mainly useful for reporting servers.# the server defaults is faster for trans Actions and fast selects.# Adjust sizes as needed,experiment to find the optimal values.# join_buffer_size=128m# sort_buffer_size=2m# read_rnd_buffer_size=2M Sql_mode=no_engine_substitution,strict_trans_tables
Revision changed to
# for advice The change settings see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * * * does not EDIT the this FILE. It's a template which'll be copied to the# * * * * default location during install,and would be replaced if you# * * * * Upgrade to a newer version of MySQL.[mysqld]# Remove Leading # and set to the amount of RAM for the most important data# caches in MySQL. Start at70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size=128m# Remove Leading # to turn on a very important data integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set,Remove the # and set as Required.basedir= "C:\work\mysql-5.6.26-winx64\mysql-5.6.26-winx64"DataDir= "C:\work\mysql-5.6.26-winx64\mysql-5.6.26-winx64\data"# port=.... # server_id=... # Remove leading # To set options mainly useful for reporting servers.# the server defaults is faster for trans Actions and fast selects.# Adjust sizes as needed,experiment to find the optimal values.# join_buffer_size=128m# sort_buffer_size=2m# read_rnd_buffer_size=2M Sql_mode=no_engine_substitution,strict_trans_tables #服务端的编码方式character-set-server=UTF8[Client]#客户端编码方式, it is best to maintain consistent loose-default-character-set with the server=UTF8[Winmysqladmin]Server= "C:\work\mysql-5.6.26-winx64\mysql-5.6.26-winx64\bin\mysqld.exe"
After modifying the configuration file, run cmd as administrator into the folder in the bin of the MySQL installation, enter Mysqld-install after running the installation service to open the service after successful operation
Run the cmd input again mysql-u root-p password is not detected by default if the installation is successful
After the installation is successful, change the password Similarly, run cmd as Administrator enter the folder in the bin of the MySQL installation mysqladmin-u root-p password carriage return
Enter the original password again enter the new password Confirm password (original password first login to empty direct return on the line)
Configuring Environment variables
Add the MySQL installation bin directory to the path.
Done
Green version of MySQL installation configuration mode