1. Manually create and 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] # Set the default character set of the mysql client to default-character-set=utf8 [mysqld] #Permission issue# Set port 3306 port = 3306 # Set the installation directory of mysql basedir=C:\Program Files (x86)\mysql-8.0.17-winx64 # Set the storage directory of mysql database data datadir=C:\Program Files (x86)\mysql-8.0.17-winx64\data # Maximum number of connections allowed max_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 a new table default-storage-engine=INNODB 2. Solution to Access denied for user 'root'@'localhost' (using password: YES) when logging in to version 8.0 Summarize The above is the problem encountered during the installation of Mysql 8.0.17 winx64 version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! You may also be interested in:
|
<<: Tutorial on deploying the open source project Tcloud with Docker on CentOS8
>>: The difference between useEffect and useLayoutEffect in React
Table of contents 1. Values within loop objects...
1. Experimental description In the virtual machin...
Table of contents Preface 1. Custom focus command...
Copy code The code is as follows: <!DOCTYPE ht...
How to introduce svg icons in Vue Method 1 of int...
Designing navigation for a website is like laying...
1. Import echart in HTML file <!-- Import echa...
Effect: css: .s_type { border: none; border-radiu...
Baidu Cloud Disk: Link: https://pan.baidu.com/s/1...
Table of contents 1. What is a transaction? 2. Th...
1. Introduction Is it considered rehashing old st...
Due to the limitation of CPU permissions, communi...
Table of contents Preface Single file components ...
Article Structure 1. Preparation 2. Install Java ...
This article originated from the homework assignm...