mysql8.0.11 Green Edition Installation Tutorial

• Unzip to the installation directory
• Create the Data folder in the root directory
• Build the My.ini file code as follows

# Otherdefaulttuning values# MySQL Server Instance Configuration file#----------------------------------------------------------------------# Generated by the MySQL Server Instance Configuration wizard### installation instructions#----------------------------------------------------------------------# # on Linux can copy ThisFile to/etc/my.cnf toSet Globaloptions,# MySQL-DATA-DIR/MY.CNF toSetserver-specific options# (@[email protected] for  Thisinstallation) or to#~/.MY.CNF toSetuser-specific options.## on Windows should keep ThisFileinchThe installation directory # of your server (e.g. C:\Program Files\mysql\mysql server x.y). to# Make sure the server reads the config file with the startup option #"--defaults-file". # # To run Run the server fromThe command line, execute This incha # command line shell, e.g.# mysqld--defaults-file="D:\GreenSoft\MySQL\my.ini"# # To install the server asA Windows service manually, execute This incha # command line shell, e.g.# mysqld--install MySQL--defaults-file="D:\GreenSoft\MySQL\my.ini"# # and then execute This incha command line shell to start the server, e.g.# net start mysql### guildlines forEditing Thisfile#----------------------------------------------------------------------# in ThisFile, you can use allLongoptions, the program supports.# If you want to know the options a program supports, start the program# with the /c5>"--help"option.## More detailed information about the individual options can also be# foundinchThe manual.## for advice in how to change settings please see# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html# # CLIENT section#----------------------------------------------------------------------# # The following options would be read by MySQL client applications.# Note This only client applications shipped by MyS QL is guaranteed# to read ThisSection . If you want your own MySQL client program to# Honor these values, you need to specify it asAn option during the# MySQL client library Initialization.#[client]no-beep# pipe# Socket=0.0Port=3306[MySQL]default-character-Set=utf8[mysqld]# This is 8.0New features of the. 4 Caching_sha2_password, using Mysql-uroot on Linux-Proot can be linked, but using the navict link under Windows is unsuccessful Default_authentication_plugin=mysql_native_password# These is commonlySet, remove the # andSet  asRequired.character-Set-server =Utf8basedir= D:\Program files\mysql-8.0. One-Winx64datadir= D:\Program files\mysql-8.0. One-Winx64\dataport=3306server_id=1# 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# General and Slow Logging.log-output=filegeneral-log=0General_log_file="CUPID.log"Slow-query-log=1Slow_query_log_file="Cupid-slow.log"Long_query_time=Ten# Binary logging.# log-bin# Error Logging.log-error="Cupid.err"# 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 #8.0. version 4, with this sql_mode, but in 8.0. Version 11 will be an error, change to the following # Sql_mode=Strict_trans_tables,no_zero_in_date,no_zero_date,error_for_division_by_zero,no_auto_create_user,no_engine_ Substitutionsql-mode="strict_trans_tables,no_engine_substitution"default-storage-engine=innodbinnodb_log_file_size=512mbinlog_format='MIXED'Max_allowed_packet=1g# innodb_file_per_table=1# Innodb_file_format=barracuda# case sensitive, 0 sensitive Linux default is 0, under Windows default value is1, the default value for MacOS is2(0 sensitive) Lower_case_table_names=1Innodb_strict_mode=0max_connections= -

View Code

• Admin mode into cmd
• CD: Under the bin of the MySQL installation directory
• Initialize MySQL

Mysqld--initialize--user=mysql--console

• The yellow box above is automatically generated MySQL temporary password, we will use this login MySQL service

• Installing the MySQL Service

Mysqld-install

• Open service

net start MySQL

• Login Service

Mysql-uroot-p Temporary password

• Change Password

Set ' Root ';

mysql8.0.11 Green Edition Installation Tutorial