当前位置: 代码迷 >> MySQL >> mysql5.6 windows免安装版装配
  详细解决方案

mysql5.6 windows免安装版装配

热度:210   发布时间:2016-05-05 16:33:39.0
mysql5.6 windows免安装版安装
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 新密码去更改密码
  相关解决方案