MySql 5.7.17 installation-free configuration tutorial details, 5.7.17 installation and configuration tutorial

MySql 5.7.17 installation-free configuration tutorial details, 5.7.17 installation and configuration tutorial

1 download mysql-5.7.17-winx64.zip installation package (link: https://dev.mysql.com/downloads/mysql)

2. Unzip the installation package.

D: \ DevelopTool \ mysql-5.7.17-winx64 # unzip the Directory

3. Create a folder named data under the extracted directory to store data.

D: \ DevelopTool \ mysql-5.7.17-winx64 \ data

4. Configure the Startup File

Copy the D: \ DevelopTool \ mysql-5.7.17-winx64 \ my-default.ini file, rename it my. ini, modify the parameters in it, as follows:

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html# *** do not edit this file. it's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128 M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = ..... ########################## basedir is the directory after the installation file is decompressed | basedir and datadir can be used relative Path # basedir =. /.. basedir = D :\\ DevelopTool \ mysql-5.7.11-winx64 # datadir is the directory used to store data # datadir =. /.. /datadatadir = D: \ DevelopTool \ mysql-5.7.11-winx64 \ data # port for port = 3306 # mar_connections for the maximum number of connections max_connections = 20character_set_server = utf8 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128 M # sort_buffer_size = 2 M # read_rnd_buffer_size = 2 M accept = truesql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

5. initialize the data directory

mysqld --defaults-file="D:\DevelopTool\mysql-5.7.17-winx64\my.ini" --initialize-insecure

It initializes the data directory. Before executing this command, delete all files in the data directory first. Otherwise, it will fail.

You can choose to use -- initialize-insecure or -- initialize for initialization, and -- initialize-insecure for initialization. the root password is blank. If you use -- initialize for initialization, a random password will be generated.

After successful execution, directory files such as mysql, perofrmance_schema, and sys will be generated under the data Directory.

6. Install and start the mysql Service

# Install mysqld-install # start the Service net start mysql # Enter mysqlmysql-u root-p # remove mysqlmysqld-remove

For mysql topics provided by this site, you can refer:

Install Mysql in various systems

Mysql Root Password Operation Skills

MySql database getting started tutorial

Database Operation Knowledge in MySQL

The above is a detailed explanation of the MySql 5.7.17 installation-free configuration tutorial. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!