Win install MySQL

Installing SQL on Windows is the most prone to 1067 errors, many of them online, mostly misleading. Now the validated steps are summarized as follows:

1. Download MySQL, I'm using Mysql-5.6.24-win32

After downloading, unzip, go to the bin directory, modify the configuration file. Modify the following:

# for advice The Change settings see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * * * Don't EDIT this FILE. It's a template which 'll be copied to the# ***defaultLocation during install, and would be replacedifyou#***upgrade to a newer version of MySQL. [mysqld]# Remove Leading # andSetTo the amount of RAM forThe most important data# cacheinchMysql. Start at -% of Total RAM forDedicated server,Else Ten%. 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 commonlySet, remove the # andSet  asrequired. Basedir= D:\Soft\Mysql\mysql-5.6. --Win32 DataDir= D:\Soft\Mysql\mysql-5.6. --win32\data# Port=.... # server_id=... # Remove leading # toSetOptions mainly useful forreporting servers.# The server defaults is faster fortransactions and fast selects.# Adjust sizes asneeded, 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

2. Start the command line tool as an administrator and go to the bin directory

Execute command:

3. Modify the Administrator password

User root password is empty after default installation

You can use commands or a third-party tool to connect to MySQL and modify it directly in the database MySQL user table.

Win install MySQL