一、復制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
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
