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