MYSQL 8.0 Installation and commissioning

Mysql:https://dev.mysql.com/downloads/mysql/8.0.html

My.ini

[Mysqld]
# Set 3306 port
port=3306
# set up the MySQL installation directory
Basedir=c:\\program files\\mysql\\mysql-8.0.11-winx64
# Set up a storage directory for MySQL database data
Datadir=c:\\program Files\\mysql\\mysql-8.0.11-winx64\\data
# Maximum number of connections allowed
max_connections=200
# Number of attempts to allow connection failures. This is to prevent someone from attempting to attack the database system from the host
max_connect_errors=10
# The default character set used by the server is UTF8
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb
# default using "Mysql_native_password" Plugin authentication
Default_authentication_plugin=mysql_native_password
[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Client]
# Set the default port to use when MySQL client connects to the server
port=3306
Default-character-set=utf8

MYSQL 8.0 Installation and commissioning