一、复制my.ini到MySQL解压的目录
例如：E:\MySQL
二、修改my.ini第39~40行
basedir = "E:\\MySQL"
datadir = "E:\\MySQL\\data"
三、检查电脑上是否安装过MySQL服务
我的电脑-->管理-->服务和应用程序-->服务，查看是否有MySQL
四、开始菜单-->附件-->命令提示符-->右键，一管理员身份运行
五、cd /d E:\MySQL\bin
mysqld -install MySQL --defaults-file="E:\MySQL\my.ini"
提示成功安装MySQL服务
六、我的电脑-->管理-->服务和应用程序-->服务，右键MySQL，点击启动。
如果启动不成，请删除E:\MySQL\data目录下的对应文件
ib_logfile0
ib_logfile1
***.err
***.pid
32位MySQL: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
# MySQL programs look for option files in a set of
8
# locations which depend on the deployment platform.
9
# You can copy this option file to one of those
10
# locations. For information about these locations, see:
11
# http://dev.mysql.com/doc/mysql/en/option-files.html
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
20
port
= 3306
21
socket
= /tmp/mysql.sock
22
default-character-set
= utf8
23
24
# Here follows entries for some specific programs
25
26
# The MySQL server
27
[mysqld]
28
port
= 3306
29
socket
= /tmp/mysql.sock
30
skip-external-locking
31
key_buffer_size
= 16K
32
max_allowed_packet
= 1M
33
table_open_cache
= 4
34
sort_buffer_size
= 64K
35
read_buffer_size
= 256K
36
read_rnd_buffer_size
= 256K
37
net_buffer_length
= 2K
38
thread_stack
= 128K
39
basedir
= "E:\\MySQL"
40
datadir
= "E:\\MySQL\\data"
41
character-set-server
= utf8
42
43
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
44
# if all processes that need to connect to mysqld run on the same host.
45
# All interaction with mysqld must be made via Unix sockets or named pipes.
46
# Note that using this option without enabling named pipes on Windows
47
# (using the "enable-named-pipe" option) will render mysqld useless!
48
#
49
#skip-networking
50
server-id
= 1
51
52
# Uncomment the following if you want to log updates
53
#log-bin
=mysql-bin
54
55
# binary logging format - mixed recommended
56
#binlog_format
=mixed
57
58
# Causes updates to non-transactional engines using statement format to be
59
# written directly to binary log. Before using this option make sure that
60
# there are no dependencies between transactional and non-transactional
61
# tables such as in the statement INSERT INTO t_myisam SELECT * FROM
62
# t_innodb; otherwise, slaves may diverge from the master.
63
#binlog_direct_non_transactional_updates
=TRUE
64
65
# Uncomment the following if you are using InnoDB tables
66
#innodb_data_home_dir
= C:\\mysql\\data\\
67
#innodb_data_file_path
= ibdata1:10M:autoextend
68
#innodb_log_group_home_dir
= C:\\mysql\\data\\
69
# You can set .._buffer_pool_size up to 50 - 80 %
70
# of RAM but beware of setting memory usage too high
71
#innodb_buffer_pool_size
= 16M
72
#innodb_additional_mem_pool_size
= 2M
73
# Set .._log_file_size to 25 % of buffer pool size
74
#innodb_log_file_size
= 5M
75
#innodb_log_buffer_size
= 8M
76
#innodb_flush_log_at_trx_commit
= 1
77
#innodb_lock_wait_timeout
= 50
78
79
[mysqldump]
80
quick
81
max_allowed_packet
= 16M
82
83
[mysql]
84
no-auto-rehash
85
# Remove the next comment character if you are not familiar with SQL
86
#safe-updates
87
88
[myisamchk]
89
key_buffer_size
= 8M
90
sort_buffer_size
= 8M
91
92
[mysqlhotcopy]
93
interactive-timeout
64位MySQL:my.ini
1
# For advice on how to change settings please see
2
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
3
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
4
# *** default location during install, and will be replaced if you
5
# *** upgrade to a newer version of MySQL.
6
7
[mysqld]
8
9
# Remove leading # and set to the amount of RAM for the most important data
10
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
11
# innodb_buffer_pool_size = 128M
12
13
# Remove leading # to turn on a very important data integrity option: logging
14
# changes to the binary log between backups.
15
# log_bin
16
17
# These are commonly set, remove the # and set as required.
18
# basedir = .....
19
# datadir = .....
20
# port = .....
21
# server_id = .....
22
basedir = D:/MySQL-5.6.20-X64
23
datadir = D:/MySQL-5.6.20-X64/data
24
port = 3306
25
#server_id = .....
26
27
character-set-server = utf8
28
default-storage-engine = INNODB
29
30
# Remove leading # to set options mainly useful for reporting servers.
31
# The server defaults are faster for transactions and fast SELECTs.
32
# Adjust sizes as needed, experiment to find the optimal values.
33
# join_buffer_size = 128M
34
# sort_buffer_size = 2M
35
# read_rnd_buffer_size = 2M
36
37
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
38
39
[client]
40
default-character-set=utf8
