MYSQL5.6.27 Compressed Edition installation Configuration Guide "Personal Summary"

MYSQL5.6.27 Compressed Edition installation Configuration Guide "Personal Summary"

1., download prepare the package360 Cloud Disk:Https://yunpan.cn/cPKyugkUcDEmP access Password 375b 2, decompression, unzip the compressed version to the D disk D:\mysql-5.6.27-winx64
3. Modify the configuration file my-default.ini # the My-default.ini file must be encoded in English (such as ANSI in Windows), not UTF-8 or GBK, etc.

# 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.# My-default.ini file must be encoded in English (such as ANSI in Windows), not UTF-8 or GBK, etc. [client]default-character-set= utf8[mysqld]# Character Set character-set-server=utf8# allow maximum number of connections max_connections=500[mysql]default-character-set=utf8# Remove Leading # and set to the amount of RAM for the most important data# caches in MySQL. Start at 70% of all RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128m# Remove Leading # to turn on a V  ery important data Integrity option:logging# changes to the binary log between backups.# log_bin# These is commonly set, Remove the # and set as required.# system basic Directory basedir = d:\mysql-5.6.27-winx64# User Data Directory DataDir = D:\mysql-5.6.27-winx64\datapor t = 3306# server_id = ... # Remove leading# to set options mainly useful for reporting servers.# the server defaults is faster for transactions and fast selects.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128m# sort_buffer_size = 2m# read_rnd_b  Uffer_size = 2M Sql_mode=no_engine_substitution,strict_trans_tables

4, the environment variable configuration, in the system variable configurationConfigure firstMysql_homeThe root directory is then configured in the PATH variable5, registered Windows Services ;Open the CMD window as an administrator and go to the MySQL installation directory bin directory, such as: D:\mysql-5.6.27-winx64\bin execute commandMysqld-installInstall the MySQL Windows service or enter mysqld installMySQL--defaults-file= "D:\mysql-5.6.27-winx64\my-default.ini" Windows services are as follows:6. Set MySQL database user name and login password ① start the MySQL service first. Method One: Method two: ② Setting the root user and its passwordThe default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. such as: 123456usually we will also set the root user's password to root, easy to remember.  after the service started successfully, you can log in, enter Mysql-u root-p ( no password for the first login, press ENTER directly ), login success!
or enter Mysql-uroot first login No password also directly enter through, login success!
Then enter subsequent commands (starting with the third line): c:>mysql –uroot   mysql>show databases;   mysql>use mysql;   mysql>UPDATE user SET password=PASSWORD("123456") WHERE user=‘root‘;   mysql>FLUSH PRIVILEGES;   mysql>QUIT 7, at this point, mysql5.6.27 compressed version has been fully configured. It is possible to use MySQL.

MYSQL5.6.27 Compressed Edition installation Configuration Guide "Personal Summary"