Windows下面安装和配置MySQL

Oct 14 2016

Windows下面安装和配置MySQL

mazerain

分类：工作

0条评论

已被围观 2196 次

1.首先到http://dev.mysql.com/ 上下载windows版mysql5.6免安装zip包。然后将zip包解压到C:\mysql下。

2.复制mysql下的my-default.ini, 在同目录下创建my.ini，my.ini为mysql的配置。最简单的配置：

[mysqld]

character-set-server=utf8

# Remove leading # to turn on a very important data integrity option: logging
# These are commonly set, remove the # and set as required.
# server_id = .....
# The TCP/IP Port the MySQL Server will listen on
port=3306

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/mysql/"

#数据文件的目录，可以更改也可以不改，为了数据安全，最好改到非系统盘，改的时候注意，把前面#去掉，再把mysql目录下的data文件夹复制到你所要的目录
#datadir="D:/data/"

character-set-server=utf8

default-storage-engine=MYISAM
max_connections=1000
query_cache_size=64M
tmp_table_size=128M
#在V5.1里table_open_cache替换table_cache做为新的变量名称，所以5.1以上的要改成table_open_cache
table_cache=256
wait_timeout=120
interactive_timeout=120
local-infile = 0
thread_cache_size=8

#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=26M
key_buffer_size=32M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K

#*** INNODB Specific options ***
#skip-innodb
innodb_buffer_pool_size = 128M
innodb_additional_mem_pool_size = 4M
innodb_log_files_in_group = 3

# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 10M
innodb_max_dirty_pages_pct = 50
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_file_per_table = 1
innodb_open_files = 100

3.计算机右键，属性，高级系统设置，高级，环境变量，系统变量。