这篇文章主要为大家分享了 mysql 5.7.16winx64 安装配置方法图文教程, 感兴趣的朋友可以参考一下
MySQL 是一个开放源码的小型关联式数据库管理系统,开发者为瑞典 MySQL AB 公司。MySQL 被广泛地应用在 Internet 上的中小型网站中。由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,许多中小型网站为了降低网站总体拥有成本而选择了 MySQL 作为网站数据库。
针对之前安装 mysql 的笔记进行了总结,分享给大家。
版本:MySQL-5.7.16-winx64
平台:Windows 7 x64
1、进入 mysql 主目录(建议将其移到 C 或 D 盘的根目录,并改名为 mysql)
2、配置 path 环境变量(如 D:\JAVA\mysql)添加到环境变量中。
3、mysql 主目录下的 my-default.ini 文件改名为 my.ini,最简单配置如下
- # For advice on how to change settings please see
- # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
- # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
- # *** default location during install, and will be replaced if you
- # *** upgrade to a newer version of MySQL.
- [mysqld]
- # Remove leading # and set to the amount of RAM for the most important data
- # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
- # innodb_buffer_pool_size = 128M
- # Remove leading # to turn on a very important data integrity option: logging
- # changes to the binary log between backups.
- # log_bin
- # These are commonly set, remove the # and set as required.
- basedir = D:\JAVA\mysql
- datadir = D:\JAVA\mysql\data
- port = 3306
- max_connections = 20
- character-set-server = utf8
- # 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
如下图所示:
上图可见,mysql 没有 data 目录,接下来我们需要初始化 data 目录
cmd 下进入 bin 目录
4、运行:mysqld --initialize
5、安装 mysql mysqld install mysql --defaults-file="D:\JAVA\mysql\my.ini"
6、启动 mysql net start mysql
后记:
在初始化时如果加上 –initial-insecure,则会创建空密码的 root@localhost 账号,否则会创建带密码的 root@localhost 账号
密码保存在:data 文件夹下的 *.err 文件中
:2016-11-25T04:05:29.713660Z 1 [Note] A temporary password is generated for root@localhost: /lSEqHkou0x%
来源: http://www.phperz.com/article/17/0320/310605.html