Troubleshooting issues encountered during Mysql 8.0. 17 winx 64 Version Installation

  • 2021-12-11 09:14:41
  • OfStack

1. Manually create and add my. ini files


# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[mysql]
#  Settings mysql Client default character set 
default-character-set=utf8
[mysqld]
# Authority issue 
#  Settings 3306 Port 
port = 3306

#  Settings mysql Installation directory of 
basedir=C:\Program Files (x86)\mysql-8.0.17-winx64
#  Settings mysql The storage directory of the data in the database 
datadir=C:\Program Files (x86)\mysql-8.0.17-winx64\data
#  Maximum number of connections allowed max_connections=200
#  The character set used by the server defaults to 8 Bit coded latin1 Character set 
character-set-server=utf8
#  Default storage engine to be used when creating new tables 
default-storage-engine=INNODB

Solution for Access denied for user 'root' @ 'localhost' (using password: YES) in version 2. 8.0 login

Summarize


Related articles: