5.7.11 mysql zip版本安装步骤(目前5.6,5.7版本有效)
1.到官网下载zip包(64位)
2.解压到个人需要的目录
Eg:H:\Program Study\mysql\mysql-5.7.11-winx64
3.修改配置文件 根目录下my-default.ini
[mysqld]
# These are commonly set, remove the # and set as required.
basedir = H:\\Program Study\mysql\mysql-5.7.11-winx64
datadir = H:\\Program Study\mysql\mysql-5.7.11-winx64\data
port = 3306
server_id = mysql
4.配置环境变量
变量名:MYSQL_HOME
变量值:H:\\Program Study\mysql\mysql-5.7.11-winx64
即为mysql的自定义解压目录。
再在Path中添加 %MYSQL_HOME%\bin
5.管理员下运行cmd转到mysql的根目录下
先mysqld --initialize
(根目录下会产生data目录)
然后mysqld -install MySQL --defaults-file="H:\Program Study\mysql\mysql-5.7.11-winx64\bin\my-default.ini"
提示安装成功
移除服务命令为:mysqld remove
最后net start mysql
可参考官方文档 如:dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
6.初次登录
>mysqld -u root -p
Password:*****(密码在data目录下,文件名.err中,找到“
2016-02-15T15:03:22.803020Z 1 [Note] A temporary password is generated for root@localhost: fSetv!rRh7Q;”。(随机字串fSetv!rRh7Q;是密码)
7.修改密码:
登录成功后执行:>ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';(new_password为新密码)