mysql56 解压安装_解压版MySQL安装说明

最新推荐文章于 2022-11-25 12:32:12 发布

吴奇霖

最新推荐文章于 2022-11-25 12:32:12 发布

阅读量202

点赞数

文章标签： mysql56 解压安装

本文链接：https://blog.csdn.net/weixin_29660305/article/details/113599928

版权

一、复制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 used4 # from time to time and it's important that the mysqld daemon5 # doesn't use much resources.6 #7 # MySQL programs look for option files in a set of8 # locations which depend on the deployment platform.9 # You can copy this option file to one of those10 # locations. For information about these locations, see:11 # http://dev.mysql.com/doc/mysql/en/option-files.html12 #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 program15 # with the "--help" option.16

17 # The following options will be passed to all MySQL clients18 [client]19 #password= your_password20 port= 330621 socket= /tmp/mysql.sock22 default-character-set= utf823

24 # Here follows entries for some specific programs25

26 # The MySQL server27 [mysqld]28 port= 330629 socket= /tmp/mysql.sock30 skip-external-locking31 key_buffer_size= 16K32 max_allowed_packet= 1M33 table_open_cache= 434 sort_buffer_size= 64K35 read_buffer_size= 256K36 read_rnd_buffer_size= 256K37 net_buffer_length= 2K38 thread_stack= 128K39 basedir= "E:\\MySQL"

40 datadir= "E:\\MySQL\\data"

41 character-set-server= utf842

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 Windows47 # (using the "enable-named-pipe" option) will render mysqld useless!48 #49 #skip-networking50 server-id= 151

52 # Uncomment the following if you want to log updates53 #log-bin=mysql-bin54

55 # binary logging format - mixed recommended56 #binlog_format=mixed57

58 # Causes updates to non-transactional engines using statement format to be59 # written directly to binary log. Before using this option make sure that60 # there are no dependencies between transactional and non-transactional61 # tables such as in the statement INSERT INTO t_myisam SELECT * FROM62 # t_innodb; otherwise, slaves may diverge from the master.63 #binlog_direct_non_transactional_updates=TRUE64

65 # Uncomment the following if you are using InnoDB tables66 #innodb_data_home_dir= C:\\mysql\\data\\67 #innodb_data_file_path= ibdata1:10M:autoextend68 #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 high71 #innodb_buffer_pool_size= 16M72 #innodb_additional_mem_pool_size= 2M73 # Set .._log_file_size to 25 % of buffer pool size74 #innodb_log_file_size= 5M75 #innodb_log_buffer_size= 8M76 #innodb_flush_log_at_trx_commit= 177 #innodb_lock_wait_timeout= 5078

79 [mysqldump]80 quick81 max_allowed_packet= 16M82

83 [mysql]84 no-auto-rehash85 # Remove the next comment character if you are not familiar with SQL86 #safe-updates87

88 [myisamchk]89 key_buffer_size= 8M90 sort_buffer_size= 8M91

92 [mysqlhotcopy]93 interactive-timeout

64位MySQL:my.ini

1 # For advice on how to change settings please see2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html3 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the4 # *** default location during install, and will be replaced if you5 # *** 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 data10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.11 # innodb_buffer_pool_size = 128M12

13 # Remove leading # to turn on a very important data integrity option: logging14 # changes to the binary log between backups.15 # log_bin16

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-X6423 datadir = D:/MySQL-5.6.20-X64/data24 port = 330625 #server_id = .....26

27 character-set-server = utf828 default-storage-engine = INNODB29

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 = 128M34 # sort_buffer_size = 2M35 # read_rnd_buffer_size = 2M36

37 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES38

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"

pauseOneKeyUninstallMySQL.bat@echo off%cd%/bin/mysqld -remove MySQLpauseOneKeyStartMySQL.bat@echo off

net startmysqlpauseOneKeyStopMySQL.bat@echo off

netstop mysqlpause

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 at70% 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.38datadir= 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.