mysql-5.7.11-winx64.zip 安装配置
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql-5.7.11-winx64.zip 安装配置,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2247字,纯文字阅读大概需要4分钟。
内容图文
![mysql-5.7.11-winx64.zip 安装配置](/upload/InfoBanner/zyjiaocheng/1313/9f7e0b2873c44d14a5384e1bda87d045.jpg)
1、下载
http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11-winx64.zip
2.解压缩zip包;
D:\Program Files\mysql-5.7.11-winx64
3.配置环境变量,
3.1 添加path路径,
D:\Program Files\mysql-5.7.11-winx64\bin
3.2.修改mysql-default.ini配置文件,
原
# These are commonly set, remove the # and set as required. # basedir = ..... # datadir = ..... # port = ..... # server_id = .....
改为
# These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.11-winx64 datadir = D:\Program Files\mysql-5.7.11-winx64\Data port = 3306 # server_id = .....
4.以管理员身份进入命令提示符 cmd
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Windows\system32>mysqld --initialize --user=mysql --console 2016-05-08T02:58:49.494014Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2016-05-08T02:58:49.530016Z 0 [Warning] ‘NO_ZERO_DATE‘, ‘NO_ZERO_IN_DATE‘ and ‘E RROR_FOR_DIVISION_BY_ZERO‘ sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2016-05-08T02:58:49.530016Z 0 [Warning] ‘NO_AUTO_CREATE_USER‘ sql mode was not s et. 2016-05-08T02:58:52.348376Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-05-08T02:58:52.869005Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-05-08T02:58:53.432037Z 0 [Warning] No existing UUID has been found, so we a ssume that this is the first time that this server has been started. Generating a new UUID: cc42ac67-14c8-11e6-90e5-08606e8d1296. 2016-05-08T02:58:53.533043Z 0 [Warning] Gtid table is not ready to be used. Tabl e ‘mysql.gtid_executed‘ cannot be opened. 2016-05-08T02:58:53.791057Z 1 [Note] A temporary password is generated for root@ localhost: UiS<C(.i(0yg C:\Windows\system32>D: D:\>cd mysql D:\mysql> D:\mysql>mysqld --install MySQL Service successfully installed. D:\mysql>net start mysql The MySQL service is starting. The MySQL service was started successfully. D:\mysql>mysql -u root -p Enter password:UiS<C(.i(0yg set password for root@localhost = password(‘hxl520‘);
原文:http://www.cnblogs.com/huxiaolin/p/5813631.html
内容总结
以上是互联网集市为您收集整理的mysql-5.7.11-winx64.zip 安装配置全部内容,希望文章能够帮你解决mysql-5.7.11-winx64.zip 安装配置所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。