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

This article mainly explains "MYSQL how to install-free configuration", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "MYSQL how to install-free configuration" bar!

Step 1: download the zip installation file

Https://downloads.mysql.com/archives/get/file/mysql-5.7.25-winx64.zip

Step 2: set mysql information

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ mysql-5.7.25-winx64# set mysql database data storage directory datadir=D:\ mysql-5.7.25-winx64\ data # allow the largest number of character sets used by the max_connections=200 # server Consider the 8-bit encoded latin1 character set character-set-server=utf8 # the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Step 3: set the mysql environment variable

Added to path; D:\ mysql-5.7.25-winx64\ bin

Step 4: add a mysql service

Cmd administrator enters

Enter mysqld install

Step 5:

Then enter

Mysqld-initialize-insecure-user=mysql

Create a login user. The user name is root by default, and the password is empty by default.

Step 6: start the service

The service has just been added. If the client wants to connect to the database, it needs to start the server process.

Net start mysql

Additional information

Thank you for reading, the above is the content of "how to install-free configuration of MYSQL". After the study of this article, I believe you have a deeper understanding of how to install-free configuration of MYSQL, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.