mysql 5.7.16 winx64安装配置方法图文教程

数据运维 2023-04-27 大猫 手机阅读

针对之前安装mysql的笔记进行了总结，分享给大家。 版本： MySQL-5.7.16-winx64 平台： Windows 7 x64 1、进入mysql主目录（建议将其移到C或D盘的根目录，并改名为mysql) 2、配置path环境变量（如

                        <p>针对之前安装mysql的笔记进行了总结，分享给大家。</p>

版本：MySQL-5.7.16-winx64平台：Windows 7 x64

1、进入mysql主目录（建议将其移到C或D盘的根目录，并改名为mysql) 2、配置path环境变量（如D:JAVAmysql）添加到环境变量中。 3、mysql主目录下的my-default.ini文件改名为my.ini，最简单配置如下

  1. For advice on how to change settings please see
  2. http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
  3. *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
  4. *** default location during install, and will be replaced if you
  5. *** upgrade to a newer version of MySQL.

[mysqld]

  1. Remove leading # and set to the amount of RAM for the most important data

  2. cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

  3. innodb_buffer_pool_size = 128M

  4. Remove leading # to turn on a very important data integrity option: logging

  5. changes to the binary log between backups.

  6. log_bin

  7. These are commonly set, remove the # and set as required. basedir = D:JAVAmysql datadir = D:JAVAmysqldata port = 3306 max_connections = 20 character-set-server = utf8

  8. Remove leading # to set options mainly useful for reporting servers.

  9. The server defaults are faster for transactions and fast SELECTs.

  10. Adjust sizes as needed, experiment to find the optimal values.

  11. join_buffer_size = 128M

  12. sort_buffer_size = 2M

  13. 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:JAVAmysqlmy.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%

精彩专题分享：mysql不同版本安装教程 mysql5.7各版本安装教程 mysql5.6各版本安装教程

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持每日运维。