Installation and configuration of MySQL

MySQL's official address: https://www.mysql.com/

Community Latest Version: 5.7.18

There are two kinds of download formats: Installer and zip two

Brief introduction in ZIP format:

Copy the contents of the compressed package to the desired directory (e.g., D:/program files/mysql)

mysql:the MySQL command-line tool command line tools

mysqld:the MySQL server MySQL service

Initialization: Mysql>mysqld-initialize

Installation Services: Mysql>mysqld-nt-install

Start service: mysql>net start MySQL (above command requires Administrator privileges)

Connection database: Mysql-uroot-p (this version requires a password to log on, the password is initialize when you create the Data folder under the \mysql\data\ computer name in the. err file)

Open File

Log in when you find your password

Installation and configuration of MySQL