# For advice on how to change settings please see
# Http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** Do not edit this file. It's a template which will be copied to
# *** Default location during install, and will 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
# Cache in MySQL. Start at 70% of total RAM for dedicated servers, else 10%.
Innodb_buffer_pool_size = 128 M
# Remove leading # to turn on a very important data integrity option: logging
# Changes to the binary log between backups.
# Log_bin
# These are commonly set, remove the # and set as required.
Basedir = D: \ mysql-5.6.14-win32
Datadir = D: \ mysql-5.6.14-win32 \ data
Port = 3306
# Custom host ID Identifier for master-slave or multi-server identification. It is an int type.
Server_id = 1
Character_set_server = utf8
# Maximum number of connections
Max_connections = 100
# The default TABLE Type of the create table statement. If the type is not specified, the downstream type is used.
Default-storage-engine = InnoDB
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
Join_buffer_size = 128 M
Sort_buffer_size = 2 M
Read_rnd_buffer_size = 2 M
SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
II,
Configure \ bin to the path of the environment variable.
3. Install mysql as a windows service.
D: \ mysql-5.6.14-win32 \ bin \ mysqld.exe-install mysql
You must specify the full path. Otherwise, the file may not be found.
Then start the mysql service.
4. log on to and change the mysql password
Run cmd to enter the command line
Mysql-u root-p
Press ENTER
Enter the database.
Use mysql;
Select host, user, password from user;
Update user set password = PASSWORD ('123456a') where user = 'root ';
Do not forget
Flush privileges;
Update OK.
Exit. Then, log on again.