Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to install MySQL5.6 unzipped version in Win7 system

2025-02-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

This article mainly tells you how to install the MySQL5.6 decompressed version of the Win7 system. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to install the MySQL5.6 decompressed version of the Win7 system can bring you some practical help.

MySQL:5.6

Operating system: Win7

2. Download MySQL 5.6

Several download addresses are provided:

Official website: https://dev.mysql.com/downloads/

Mirror: http://mirrors.163.com/

3. Decompression

4. Configure environment variables

Specific address: path:E:\ SystemTools\ mysql-5.6.41-winx64\ bin

5. Configure MySQL configuration file

Make a copy of my-default.ini and rename it to my.ini, and modify its content to:

# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/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. [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] character-set-server=utf8# 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 = 128M# 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 = E:\ SystemTools\ mysql-5.6.41-winx64datadir = D:\ SystemTools\ mysql-5.6.41-winx64\ data# port =. # server_id = .# 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 = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2m sql_mode=NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES

Effect picture

6. Install the MySQL service

Command:

Mysqld-install # # install MySQL service mysqld-remove # # Uninstall MySQL service net start mysql # # start MySQL service net stop mysql # # stop MySQL service

7. Log in to the MySQL database and change the password

MySQL has just been installed. Root does not have a user password and can be logged in directly, as follows:

Win7 system how to install MySQL5.6 decompression version to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report