mysql5.6 windows免安装版安装的方法,mysql 5.6 后,可以 windows下免install安装,
但注意如果有5.5的话,要注意下
1) 解压安装后,默认my-default.init是需要修改的
# These are commonly set, remove the # and set as required.
basedir = E:/mysql56
datadir = E:/mysql56/data
port = 3306
# 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
[client]
# 设置mysql客户端的字符集
default-character-set=utf-8
要打开basedir,datadir,这个最起码
2) 然后安装服务,一定要到5.6的所在bin目录下,否则用可能因为之前mysql5.5加了path ,
会用错mysql 5.5的
C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld"
--install MySQL --defaults-file=C:\my-default.ini
--install后参数是安装成的服务名称
注意win 7下要在命令行下管理员模式启动
3) 然后mysqladmin -u root -p password 新密码去更改密码