mysql5.6 windows免安装版装配_mysql

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 新密码去更改密码

欢迎大家阅读《mysql5.6 windows免安装版装配_mysql》,跪求各位点评，by 搞代码

喜欢 (0)赏

[搞代码]

分享 (0)