mysql5.6之windows绿色启动

最新推荐文章于 2022-07-08 22:31:59 发布

nnsword

最新推荐文章于 2022-07-08 22:31:59 发布

阅读量1.7k

点赞数

分类专栏：数据库学习记录 mysql

本文链接：https://blog.csdn.net/nnsword/article/details/82025677

版权

本文指导如何在Windows上为MySQL5.6创建批处理文件start.bat和配置文件my.ini，实现绿色便捷启动。

摘要由CSDN通过智能技术生成

在mysql目录创建批处理 start.bat

@echo off
@echo Mysql startup ...
start bin\mysqld.exe --defaults-file=my.ini --port=3306
exit

在mysql目录创建配置 my.ini

# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password   = your_password
port        =