MySQL configuration file

[MySQL]# Set the MySQL client default character setdefault-character-Set=UTF8[mysqld]#设置3306端口port= 3306# Set up the MySQL installation directory Basedir=d:\mysql# Set the data storage directory for the MySQL database DataDir=d:\mysql\data# Maximum number of connections allowed Max_connections= $# The character set used by the service side defaults to the 8-bit encoded latin1 character Setcharacter-Set-Server=utf8# default storage engine to use when creating a new tabledefault-Storage-Engine=INNODB

In run (win+r) input drivers change hosts to the removal of localhost

Configure environment variables Create a new My.ini under the MySQL folder

Under Administrator privileges

Mysqld--install

net start MySQL

MySQL configuration file