解压版MySQL安装说明

一、复制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      

 四个windows的脚本：

OneKeyInstallMySQL.bat
@echo off
%cd%/bin/mysqld -install MySQL --defaults-file="D:\MySQL-5.6.24\my.ini"
pause

OneKeyUninstallMySQL.bat
@echo off
%cd%/bin/mysqld -remove MySQL
pause

OneKeyStartMySQL.bat
@echo off
net start mysql
pause

OneKeyStopMySQL.bat
@echo off
net stop mysql
pause      

 MySQL-5.6.38的my.ini

# 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.
[client]

default-character-set=utf8

[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:\MySQL-5.6.38
datadir = D:\MySQL-5.6.38\data
character-set-server=utf8
# port = .....
# server_id = .....

# 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 = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES       

命令行查看编码和存储引擎的命令：

作者：

Candyメ奶糖

出处：

http://www.cnblogs.com/Candies/

本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。

博文来源广泛，如原作者认为我侵犯知识产权，请尽快给我发邮件

[email protected]

联系，我将以第一时间删除相关内容。