暂无图片
mysql5.7.17初始化求助
我来答
分享
刺史武都
2020-08-07
mysql5.7.17初始化求助

安装了一个非压缩版本的5.7.17,初始化总是出错,显示:could not open required defaults file C:\Program Files\MySQL\MySQL Server 5.7\my.ini
使用的命令行为 : --initialize --console
求大神指点!!!还未入门级小白
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 = C:\Program Files\MySQL
datadir = C:\Program Files\MySQL\MySQL Server 5.7\data
port = 3306
character_set_server=utf8
# 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

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
Cui Hulong

在dos里面登录进去,按照一下方式自动目录配置文件
bin\mysqld --defaults-file=C:\mysql\my.ini --initialize-insecure --console
把执行的命令,截图出来共享一下

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏