This article has shared the MySQL 8.0.17 installation picture and text tutorial for your reference, the specific content is as follows
Installation environment:windows x64
1. Download the installation package
Download address: installation package
2. Decompression and initialization configuration
Unzip and create a new initialization configuration file in the root directory my.ini
Enter the following contents in the initialization configuration file. Pay attention to change the installation path and data storage path to your own
[mysqld] \#Set port 3306 port=3306 \#Set the installation directory of MySQL basedir=D:\App\mySQL \#Set the data storage directory of MySQL database datadir=D:\App\mySQL\data \#Maximum number of connections allowed max_connections=200 \#The number of connection failures allowed. max_connect_errors=10 \#The character set used by the server is utf8mb4 by default character-set-server=utf8mb4 \#The default storage engine that will be used when creating new tables default-storage-engine=INNODB \#The default is "MySQL"_ native_ "Password" plug-in authentication \#mysql_native_password default_authentication_plugin=mysql_native_password [mysql] \#Setting the default character set of MySQL client default-character-set=utf8mb4 [client] \#Set the default port for MySQL client to connect to the server port=3306 default-character-set=utf8mb4
3. Start installation
Open CMD as administrator to install
First, enter the bin directory
Input commandmysqld –initialize –consoleEnter to display the following fields, where[email protected]:The following field is the initial password, copy and save!
Then install the MySQL service and run it in the bin directorymysqld –installThere is no service name added here. The default is mysql
It’s a success here!
4. Start MySQL service
In the command line input: Net start MySQL can start it!
Wonderful topic sharing:
Installation of different versions of MySQL
Installation tutorial of mysql5.7
Installation tutorial of mysql5.6
Installation tutorial of mysql8.0
The above is the whole content of this article, I hope to help you learn, and I hope you can support developer more.