win安装mysql-noinstall指南1，下载mysql：http://download.mysql.cn/文件名：mysql-noinstall-5.0.22(win32)
win安装mysql-noinstall指南
1，下载mysql：http://download.mysql.cn/
文件名：mysql-noinstall-5.0.22(win32)
2.加压缩导任何一个目录，最好目录名称不要有空格；
例如：D:\DevelopTools\mysql-5.0.22-win32
3，在mysql-5.0.22-win32
目录下新建一个my.ini，拷贝my-small.ini代码至my.ini；修改后如下：
?1#?Example?MySQL?config?file?for?small?systems.
?2#
?3#?This?is?for?a?system?with?little?memory?(<=?64M)?where?MySQL?is?only?used
?4#?from?time?to?time?and?it's?important?that?the?mysqld?daemon
?5#?doesn't?use?much?resources.
?6#
?7#?You?can?copy?this?file?to
?8#?/etc/my.cnf?to?set?global?options,
?9#?mysql-data-dir/my.cnf?to?set?server-specific?options?(in?this
10#?installation?this?directory?is?/usr/local/var)?or
11#?~/.my.cnf?to?set?user-specific?options.
12#
13#?In?this?file,?you?can?use?all?long?options?that?a?program?supports.
14#?If?you?want?to?know?which?options?a?program?supports,?run?the?program
15#?with?the?"--help"?option.
16
17#?The?following?options?will?be?passed?to?all?MySQL?clients
18[client]
19#password????=?your_password
20port????????=?3306
21socket????????=?/tmp/mysql.sock
22#这里是我们增加的内容
23#设置客户端字符集
24default-character-set=gbk
25#?Here?follows?entries?for?some?specific?programs
26
27#?The?MySQL?server
28[mysqld]
29port????????=?3306
30socket????????=?/tmp/mysql.sock
31skip-locking
32key_buffer?=?16K
33max_allowed_packet?=?1M
34table_cache?=?4
35sort_buffer_size?=?64K
36read_buffer_size?=?256K
37read_rnd_buffer_size?=?256K
38net_buffer_length?=?2K
39thread_stack?=?64K
40#这里是我们修改的内容
41basedir=D:\DevelopTools\mysql-5.0.22-win32
42#?设置mysql数据库的数据的存放目录，必须是data，或者是\\xxx\data?
43datadir=D:\DevelopTools\mysql-5.0.22-win32\data
44#?设置mysql服务器的字符集
45default-character-set=utf8
46
47#?Don't?listen?on?a?TCP/IP?port?at?all.?This?can?be?a?security?enhancement,
48#?if?all?processes?that?need?to?connect?to?mysqld?run?on?the?same?host.
49#?All?interaction?with?mysqld?must?be?made?via?Unix?sockets?or?named?pipes.
50#?Note?that?using?this?option?without?enabling?named?pipes?on?Windows
51#?(using?the?"enable-named-pipe"?option)?will?render?mysqld?useless!
52#?
53#skip-networking
54server-id????=?1
55
56#?Uncomment?the?following?if?you?want?to?log?updates
57#log-bin=mysql-bin
58
59#?Uncomment?the?following?if?you?are?NOT?using?BDB?tables
60#skip-bdb
61
62#?Uncomment?the?following?if?you?are?using?InnoDB?tables
63#innodb_data_home_dir?=?/usr/local/var/
64#innodb_data_file_path?=?ibdata1:10M:autoextend
65#innodb_log_group_home_dir?=?/usr/local/var/
66#innodb_log_arch_dir?=?/usr/local/var/
67#?You?can?set?.._buffer_pool_size?up?to?50?-?80?%
68#?of?RAM?but?beware?of?setting?memory?usage?too?high
69#innodb_buffer_pool_size?=?16M
70#innodb_additional_mem_pool_size?=?2M
71#?Set?.._log_file_size?to?25?%?of?buffer?pool?size
72#innodb_log_file_size?=?5M
73#innodb_log_buffer_size?=?8M
74#innodb_flush_log_at_trx_commit?=?1
75#innodb_lock_wait_timeout?=?50
76
77[mysqldump]
78quick
79max_allowed_packet?=?16M
80
81[mysql]
82no-auto-rehash
83#?Remove?the?next?comment?character?if?you?are?not?familiar?with?SQL
84#safe-updates
85
86[isamchk]
87key_buffer?=?8M
88sort_buffer_size?=?8M
89
90[myisamchk]
91key_buffer?=?8M
92sort_buffer_size?=?8M
93
94[mysqlhotcopy]
95interactive-timeout
96
4，然后编写启动脚本；
1@echo?off
2echo?start?mysql5?on?localhost
3mysqld?--install?mysql5?--defaults-file=D:\DevelopTools\mysql-5.0.22-win32\my.ini
4net?start?mysql5
5pause
6
7
8
9
停止脚本
1@echo?off
2echo?stop?mysql5
3
4net?stop?mysql5
5mysqld?--remove?mysql5
6
7pause
?
