MySQL 8.0.18 installation and configuration graphic tutorial

Learning objectives: Learn to use Windows system to install MySQL database , for your reference, the specific content is as follows

1. Open the browser and enter the download address of the SQL official website: Download link

2. After downloading the MySQL software package, create a web folder in the C drive, unzip the MySQL file to the web folder, and create a my.ini file in the mysql directory.

3. Open the my.ini configuration file and enter the following content

[client]
#Set the default character set of MySQL client default-character-set=utf8

[mysqld]
#Set port 3306 port = 3306
#Set the installation directory of mysql basedir=C:\web\mysql-8.0.18
#Set the data storage directory of MySQL database. MySQL 8+ does not need the following configuration, the system will automatically generate #datadir=C:\web\sqldata
#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 

4. Start the MySQL database (open the cmd command tool as an administrator)

5. Use exit or quit to exit the database

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.