Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "MySQL 5.7.17 installation-free version of the sample analysis", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn the "MySQL 5.7.17 installation-free version of the sample analysis" of this article.

MYSQL version: MySQL Community Server 5.7.17, installation-free version, the details are as follows

Download address: https://dev.mysql.com/downloads/mysql/

Computer system: notebook win10,64 bit

1. Download and decompress

Download it and decompress it locally.

The decompressed file is as follows

2. Create a new my.ini file

Copy the my-default.ini file and paste it, rename it to my.ini

Then replace the text content with

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=E:\ dataBase\ mysql-5.7.17-winx64# set mysql database data storage directory datadir=E:\ dataBase\ mysql-5.7.17-winx64\ data# allows the character set used by the most Dalian connection max_connections=200# server to default to 8-bit encoding The default storage engine default-storage-engine=INNODB that the latin1 character set character-set-server=utf8# will use when creating new tables

Note that E:\ dataBase\ mysql-5.7.17-winx64 above should be changed to your own computer's file location.

3. Creation of data file

Run and open cmd as an administrator.

Change the file directory to E:\ dataBase\ mysql-5.7.17-winx64\ bin (the path depends on where you installed it).

Type mysqld-- initialize-insecure-- user=mysql to wait a while to open the directory and you will find a new data folder.

4. Start mysql

Continue to enter the service installation command under bin >:

Mysqld install MySQL-- defaults-file= "E:\ dataBase\ mysql-5.7.17-winx64\ my.ini"

Pay attention to replacement.

An error will be reported here: The service already exists!

Then continue typing: mysqld-remove

Then enter: mysqld install MySQL-- defaults-file= "E:\ dataBase\ mysql-5.7.17-winx64\ my.ini"

At this point, it displays: Service successfully installed.

Then enter the startup instruction: net start mysql

5. Local environment configuration

"create" a variable named "MYSQL_HOME" in the system environment variable. Variable value: "E:\ dataBase\ mysql-5.7.17-winx64"

Edit the existing environment variable "Path" and add "% MYSQL_HOME%\ bin" at the end.

The above is all the contents of the article "sample Analysis of the installation-free version of MySQL 5.7.17". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.