Shulou(Shulou.com)06/01 Report--

Learning goal: learn to use windows system to install MySQL database for your reference, the specific contents are as follows

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

two。 After downloading the MySQL software package, create a web folder under disk C, extract the MySQL file to the web file, and create a my.ini file under the mysql directory.

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

[client] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=C:\ web\ mysql-8.0.18# set mysql database data storage directory, mysql 8 + does not need to be configured below The system automatically generates # datadir=C:\ web\ sqldata# allows the maximum number of connections the character set used by the max_connections=20# server defaults to the 8bite-encoded Latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

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:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.