Solve the problems encountered in the installation of MySQL 8.0.17 winx64


1、 Manually create add my.ini file

# ----------------------------------------------------------------------
# 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.
#Setting the default character set of MySQL client
#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
#The default storage engine that will be used when creating new tables

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


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 […]