MYSQL5.6数据库ZIP安装以及VS中使用注意事项

Home

Database

Mysql Tutorial

MYSQL5.6数据库ZIP安装以及VS中使用注意事项_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:18 PM

download linkdatabaseresource

bitsCN.com

先挂资源，下载地址： http://download.softagency.net/MySQL/Downloads/。

找到MYSQL5.6，两个版本看系统而定我下的是64位的：http://download.softagency.net/MySQL/Downloads/MySQL-5.6/mysql-5.6.16-winx64.zip。解压放入自己需要存入的地方，我的路径是D:/SDT/mysql5.6.16_x64,如下图所示:

解压后目录里面的文件可能会和图片里有点不一样，没有my.ini和my_default_old.ini这个两个文件，并且有一个my_default.ini文件。这是接下来要弄的，把my_default.ini文件在当前文件夹下复制粘贴一份，并把其它一个文件名改成my.ini，另一个可以不管或改成我上面样子。

my.ini的配置文件需要改两处理地方:

basedir = D://SDT//mysql5.6.16_x64
datadir = D://SDT//mysql5.6.16_x64//data

port = 3306
#自定义主机ID识别符，用于主从或多服务器之间识别，为一个 int 类型
server_id = 1

或

basedir = D:/SDT/mysql5.6.16_x64
datadir = D:/SDT/mysql5.6.16_x64/data

port = 3306
#自定义主机ID识别符，用于主从或多服务器之间识别，为一个 int 类型
server_id = 1

这里需要注意的就是正斜杠是两个，反斜杠是一个，任意一种都行，其它可改可不改，我的完整配置如下：

# 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.[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 = 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 = D://SDT//mysql5.6.16_x64datadir = D://SDT//mysql5.6.16_x64//dataport = 3306#自定义主机ID识别符，用于主从或多服务器之间识别，为 一个 int 类型server_id = 1character_set_server=utf8# 最大连接数量max_connections = 100#CREATE TABLE 语句的默认表类型，如果不自己指定类型，则使用下行的类型default-storage-engine = InnoDB# 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 = 128Msort_buffer_size = 2Mread_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

　接下来是在环境变量”path“里加入数据库根目录路径，如我的就是"D:/SDT/mysql5.6.16_x64/bin"。

打开cmd控制台,win7系统要以管理员权限打开，输入"D:/SDT/mysql5.6.16_x64/bin/mysqld.exe --install mysql5"，一定要以全路径，正常操作应该是显示安装成功的英文。这里的命令大概意思是建立一个mysql5的数据库服务实例。如果不以全路径等下会启动不了，想知道为什么，可以在运行里输入"services.msc"看下我们建的这个mysql5服务的运行目录就明白了。

接着在CMD里输入"net start mysql5"，启动我们刚才建的"mysql5"实例,正常操作应该是显示数据服务成功开启的英文。

下一步配置root密码,在cmd里输入"mysql -u root -p"，因为数据库默认root是没有密码的，所以直接回车两下就可以下，接下来输入"update user set password=PASSWORD(‘123456’) where User='root';"其中"123456"是为要更新的密码，更据实际改下就行了。

数据库目前是以基本配置完了，接下来可以下一个“MySQLWorkbench”,我下的是6.0.7版本的，资源还是最上面的目录里去找。解压放入自己需要的文件目录，这里需要注意的是目录路径最好是英文，要不可能报错，反正我的WIN7放中文目录里是出错，报的是好像是要什么ansi环境。打开MySQLWorkbench.exe，Databse->conect to database，填入用户名和密码及上面的root和123456，就可以图形界面操作mysql了。

接下来VS里集成mysql，网上找了一把发现6.7xx以上的.net_connecter已经不vs集成插件了，需要用mysql-install这个工具下载地址：

http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-community-5.6.16.0.msi，这个就不说了，看着点就可以了。

再来一个web版在线安装版:

http://cdn.mysql.com/Downloads/MySQLInstaller/mysql-installer-web-community-5.7.3.0-m13.msi

bitsCN.com

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Explain the ACID properties (Atomicity, Consistency, Isolation, Durability).Apr 16, 2025 am 12:20 AM

ACID attributes include atomicity, consistency, isolation and durability, and are the cornerstone of database design. 1. Atomicity ensures that the transaction is either completely successful or completely failed. 2. Consistency ensures that the database remains consistent before and after a transaction. 3. Isolation ensures that transactions do not interfere with each other. 4. Persistence ensures that data is permanently saved after transaction submission.

MySQL: Database Management System vs. Programming LanguageApr 16, 2025 am 12:19 AM

MySQL is not only a database management system (DBMS) but also closely related to programming languages. 1) As a DBMS, MySQL is used to store, organize and retrieve data, and optimizing indexes can improve query performance. 2) Combining SQL with programming languages, embedded in Python, using ORM tools such as SQLAlchemy can simplify operations. 3) Performance optimization includes indexing, querying, caching, library and table division and transaction management.

MySQL: Managing Data with SQL CommandsApr 16, 2025 am 12:19 AM

MySQL uses SQL commands to manage data. 1. Basic commands include SELECT, INSERT, UPDATE and DELETE. 2. Advanced usage involves JOIN, subquery and aggregate functions. 3. Common errors include syntax, logic and performance issues. 4. Optimization tips include using indexes, avoiding SELECT* and using LIMIT.

MySQL's Purpose: Storing and Managing Data EffectivelyApr 16, 2025 am 12:16 AM

MySQL is an efficient relational database management system suitable for storing and managing data. Its advantages include high-performance queries, flexible transaction processing and rich data types. In practical applications, MySQL is often used in e-commerce platforms, social networks and content management systems, but attention should be paid to performance optimization, data security and scalability.

SQL and MySQL: Understanding the RelationshipApr 16, 2025 am 12:14 AM

The relationship between SQL and MySQL is the relationship between standard languages and specific implementations. 1.SQL is a standard language used to manage and operate relational databases, allowing data addition, deletion, modification and query. 2.MySQL is a specific database management system that uses SQL as its operating language and provides efficient data storage and management.

Explain the role of InnoDB redo logs and undo logs.Apr 15, 2025 am 12:16 AM

InnoDB uses redologs and undologs to ensure data consistency and reliability. 1.redologs record data page modification to ensure crash recovery and transaction persistence. 2.undologs records the original data value and supports transaction rollback and MVCC.

What are the key metrics to look for in an EXPLAIN output (type, key, rows, Extra)?Apr 15, 2025 am 12:15 AM

Key metrics for EXPLAIN commands include type, key, rows, and Extra. 1) The type reflects the access type of the query. The higher the value, the higher the efficiency, such as const is better than ALL. 2) The key displays the index used, and NULL indicates no index. 3) rows estimates the number of scanned rows, affecting query performance. 4) Extra provides additional information, such as Usingfilesort prompts that it needs to be optimized.

What is the Using temporary status in EXPLAIN and how to avoid it?Apr 15, 2025 am 12:14 AM

Usingtemporary indicates that the need to create temporary tables in MySQL queries, which are commonly found in ORDERBY using DISTINCT, GROUPBY, or non-indexed columns. You can avoid the occurrence of indexes and rewrite queries and improve query performance. Specifically, when Usingtemporary appears in EXPLAIN output, it means that MySQL needs to create temporary tables to handle queries. This usually occurs when: 1) deduplication or grouping when using DISTINCT or GROUPBY; 2) sort when ORDERBY contains non-index columns; 3) use complex subquery or join operations. Optimization methods include: 1) ORDERBY and GROUPB

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Best Graphic Settings

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

2 weeks agoByDDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Chat Commands and How to Use Them

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Atom editor mac version download

The most popular open source editor

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.