I'll record the problems I encountered during the installation process, and I hope it will be useful to everyone. 1. Download (the official recommendation is to download and install the version, but the decompressed version is more convenient), download address: 2. To decompress, we need to add one more step: (1) Create a file named my.ini. Addendum: I created a data folder before, but the subsequent installation resulted in an error. Take this as a warning. 3. Modify the my.ini file: [mysql] # Set the default character set of the mysql client to default-character-set=utf8 [mysqld] # Set port 3306 port = 3306 # Set the installation directory of mysql basedir = D:\\Program Files\\mysql\\ # Set the storage directory of mysql database data datadir = D:\\Program Files\\mysql\\data # Maximum number of connections allowed max_connections=20 # 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 # Create mode sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES Pay special attention to: (1) The directory D:\\Program Files\\mysql\\data must be “\\”. Do not use “\” or an error will be reported. Alternatively, you can use “/”. 4. Configure mysql environment variables: Click Path and add: 5. Run cmd as an administrator and do the following: (1) Switch to the bin directory of mysql; (3) Execute the mysqld --install command to install the mysqld service; (4) Execute the net start mysql command to start the MySQL service; (5) Execute the mysql -u root -p command to connect to the MySQL database and enter the randomly generated password above; (6) Execute the following SQL to reset the root password: mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'new password'; Tips:
Wonderful topic sharing: MySQL different versions installation tutorial MySQL 5.7 installation tutorials for various versions MySQL 5.6 installation tutorials for various versions mysql8.0 installation tutorials for various versions The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM. You may also be interested in:
|
<<: How to use the Linux nl command
>>: How to switch between Vue production and development environments and use filters
Ordered List XML/HTML CodeCopy content to clipboa...
URL rewriting helps determine the preferred domai...
Table of contents Preface 1. Why do cross-domain ...
To be honest, this question involves a lot of cor...
Related Documents Part of this article is referen...
1. Overview This article systematically explains ...
Container auto-start Docker provides a restart po...
【Foreword】 The SMS function of our project is to ...
This article mainly introduces the sample code of...
Table of contents 1 Test Environment 1.1 Server H...
I have been learning about algorithms recently an...
Preface To be honest, I've been feeling very ...
GitHub address, you can star it if you like it Pl...
The differences among execute, executeUpdate, and...
Docker installs MySQL version 8.0.20 for your ref...