Solve the problems encountered in the installation of MySQL 8.0.17 winx64

Time:2021-3-1

1、 Manually create add my.ini file

# 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]
#Setting the default character set of MySQL client
default-character-set=utf8
[mysqld]
#Authority issues
#Set port 3306
port = 3306

#Set the installation directory of MySQL
basedir=C:\Program Files (x86)\mysql-8.0.17-winx64
#Set the data storage directory of MySQL database
datadir=C:\Program Files (x86)\mysql-8.0.17-winx64\data
#Max connections allowed_ connections=200
#The default character set used by the server is the 8-bit Latin1 character set
character-set-server=utf8
#The default storage engine that will be used when creating new tables
default-storage-engine=INNODB

2、 Solution to access denied for user ‘root’ @’localhost ‘(using password: Yes) in version 8.0

summary

The above are the problems encountered in the installation of MySQL 8.0.17 winx64 introduced by Xiaobian. I hope it can help you. If you have any questions, please leave me a message and Xiaobian will reply you in time. Thank you very much for your support to developer!
If you think this article is helpful to you, please reprint, please indicate the source, thank you!

Recommended Today

Review of SQL Sever basic command

catalogue preface Installation of virtual machine Commands and operations Basic command syntax Case sensitive SQL keyword and function name Column and Index Names alias Too long to see? Space Database connection Connection of SSMS Connection of command line Database operation establish delete constraint integrity constraint Common constraints NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY DEFAULT […]