• MySQL解压版配置方法


    1.下载

    https://downloads.mysql.com/archives/community/

    2. 创建my.ini文件。复制如下文档

    [mysqld]
    character-set-server=utf8
    bind-address = 0.0.0.0
    port = 3306
    basedir=D:/mysql-5.7.24-winx64
    datadir=D:/MySQL_Data_DFN_FT/data
    max_connections=2000
    default-storage-engine=INNODB
    [mysql]
    default-character-set=utf8
    [mysql.server]
    default-character-set=utf8
    [client]
    default-character-set=utf8

    3. 拷贝到解压目录

    4.添加环境变量

    管理员方式运行CMD,安装服务。mysqld --install mysql

    5.  初始化data文件夹,mysqld --initialize --user=root --console,(如何设置mysql的默认密码)

    my.ini中:datadir=D:/MySQL_Data_DFN_FT/data,自己先创建MySQL_Data_DFN_FT的目录,data文件就会自动生成到这里。

    自动生成root,的登录密码。

    6. 启动服务, net start mysql

    C:WINDOWSsystem32>net start mysql
    mysql 服务正在启动 .
    mysql 服务已经启动成功。

    7. 登录root用户。mysql -uroot -pafyysw,7exwG

    C:WINDOWSsystem32>mysql -uroot -pafyysw,7exwG
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor. Commands end with ; or g.
    Your MySQL connection id is 2
    Server version: 5.7.24

    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

    8. 修改密码

    mysql> set password =password('root');//括号里面的root就是密码
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    9.退出

    mysql> exit
    Bye

    10.测试登录 C:WINDOWSsystem32>mysql -uroot -proot

    C:WINDOWSsystem32>mysql -uroot -proot
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor. Commands end with ; or g.
    Your MySQL connection id is 8
    Server version: 5.7.24 MySQL Community Server (GPL)

    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

    mysql> exit
    Bye

    欢迎讨论,相互学习。 txwtech@163.com
  • 相关阅读:
    如何给wordpress外部链接自动添加nofollow
    wordpress如何批量关闭旧日志留言功能
    如何一次把所有wordpress插件都禁用了
    sql批量获取wordpress所有留言者的邮件地址
    wordpress数据库优化-关闭日志修订
    wordpress数据库优化wp_posts表 OPTIMIZE
    sql批量删除wordpress所有日志修订revision
    sql删除wordpress没用的postmeta记录
    wordpress如何删除没有文章的tags标签
    批量删除wordpress垃圾评论留言
  • 原文地址:https://www.cnblogs.com/txwtech/p/14751496.html
Copyright © 2020-2023  润新知