解压版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
命令行查看编码和存储引擎的命令：
