mysql-5.7.xx-winx64服务无法启动解决方案

傷城~ 2022-06-01 00:50 316阅读 0赞

**一、解压mysql压缩包5.7后没有data文件夹**

使用net start mysql命令启动服务失败。

![服务启动][SouthEast]

可以使用mysqld remove移除服务，重新注册。

**二、正确的流程**

1.添加添加环境变量，指定到bin目录， 使用mysqld --initialize-insecure 命令初始化处理

自动创建data文件夹和data中的文件

![SouthEast 1][]

![SouthEast 2][]

2.添加自己的配置文件 内容

[client] 
    port=3306 
    default-character-set=utf8 
    [mysqld] 
    port=3306 
    character_set_server=utf8 
    # 指定表名、数据库名是否区分大小写
    #lower_case_table_names=0
    # 指定数据库默认编码
    #default_character_set=utf8
    
    # These are commonly set, remove the # and set as required.
     basedir=G:\Developer\mysql-5.7.21-winx64
     datadir=G:\Developer\mysql-5.7.21-winx64\data
    # port = .....
    # 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

特别注意：lower\_case\_table\_names=0 如果在5.7中制定区分大小写，则服务启动失败，初始化创建dadta也会失败

3.使用mysqld intall 命令安装服务，安装成功后使用net start mysql 命令启动服务

注：以上命令需要以管理员身份运行。

[MySQL 5.6 for Windows 解压缩版配置安装][MySQL 5.6 for Windows]

[MySQL-5.6.13免安装版配置方法][MySQL-5.6.13]

[MySQL(root用户)密码重置][MySQL_root]

[SouthEast]: /images/20220601/596487e8405247b386f321965a210ce6.png
[SouthEast 1]: /images/20220601/800554246023489099418032b5efb7ae.png
[SouthEast 2]: /images/20220601/2b5ad637271740938dd9fe04aefec0ef.png
[MySQL 5.6 for Windows]: http://blog.csdn.net/u011127019/article/details/45438411
[MySQL-5.6.13]: http://blog.csdn.net/u011127019/article/details/48518363
[MySQL_root]: http://blog.csdn.net/u011127019/article/details/48542715