Install and use MySql

Install and use MySql

Because the MySql database is used in the graduation project today, you have to Install a MySQL database by yourself. However, since MySQL Install MSI is only 32-bit, you finally choose to useWindows (x86, 64-bit), ZIP ArchiveFor the installation and use of the version, I will introduce the process of installing MySQL by myself, for your reference only.

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ MySql \ mysql-5.7.12-winx64 # Set the mysql database data storage directory datadir = D: \ MySql \ mysql-5.7.12-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

• Save the file after adding it, and create an empty data folder in this path. The following figure shows the structure of the entire process: