• 关于mysql安装过程中命令mysqld --initialize --console出错的解答


    在进行mysql数据库安装时遇到以下问题,在网上找了一圈高赞帖子,但是都没有解决。

    F:studymysqlmysql-8.0.25-winx64in>mysqld --initialize --console
    2021-07-11T14:28:40.798214Z 0 [System] [MY-013169] [Server] F:studymysqlmysql-8.0.25-winx64inmysqld.exe (mysqld 8.0.25) initializing of server in progress as process 5896
    2021-07-11T14:28:40.815000Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
    2021-07-11T14:28:40.815015Z 0 [ERROR] [MY-013236] [Server] The designated data directory F:studymysqlmysql-8.0.25-winx64 is unusable. You can remove all files that the server added to it.
    2021-07-11T14:28:40.821104Z 0 [ERROR] [MY-010119] [Server] Aborting
    2021-07-11T14:28:40.822328Z 0 [System] [MY-010910] [Server] F:studymysqlmysql-8.0.25-winx64inmysqld.exe: Shutdown complete (mysqld 8.0.25)  MySQL Community Server - GPL.

    最后的解决的措施有2步:

    1、设置my.ini文件(如下)

    2、设置数据库的数据存放目录:datadir=F:/study/mysql/mysql-8.0.25-winx64/data,同时确保data目录下没有文件,为空

    3、将mysql安装地址配置到系统环境变量

    [mysqld]
    # 设置3306端口
    port=3306
    # 设置mysql的安装目录
    basedir=F:/study/mysql/mysql-8.0.25-winx64
    # 设置mysql数据库的数据的存放目录
    datadir=F:/study/mysql/mysql-8.0.25-winx64/data
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。
    max_connect_errors=10
    # 服务端使用的字符集默认为utf8mb4
    character-set-server=utf8mb4
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 默认使用“mysql_native_password”插件认证
    #mysql_native_password
    default_authentication_plugin=mysql_native_password
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8mb4
    [client]
    # 设置mysql客户端连接服务端时默认使用的端口
    port=3306
    default-character-set=utf8mb4

    再次执行就ok了.

    F:studymysqlmysql-8.0.25-winx64in>mysqld --initialize --console
    2021-07-11T14:55:39.337661Z 0 [System] [MY-013169] [Server] F:studymysqlmysql-8.0.25-winx64inmysqld.exe (mysqld 8.0.25) initializing of server in progress as process 17800
    2021-07-11T14:55:39.446137Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
    2021-07-11T14:55:43.233879Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
    2021-07-11T14:55:49.341436Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: XXXXXX
  • 相关阅读:
    第二次站立会议
    小组第一次站立会议
    用户场景描述
    本周学习总结
    构建之法阅读笔记之三
    本周的学习收获
    java连接Oracle数据库
    scott用户不存在
    大二暑假第五周总结
    业务用例分析
  • 原文地址:https://www.cnblogs.com/aszeno/p/15000101.html
Copyright © 2020-2023  润新知