Git Product home page Git Product logo

mysql-'s Introduction

安装mysql

  1. 压缩包下载地址 第一个

  2. 解压压缩包

  3. 打开文件,配置bin目录到系统环境变量

  4. 新建my.ini文件

    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8
    [mysqld]
    # 设置3306端口
    port = 3306
    # 设置mysql的安装目录
    basedir = D:\\mysql\\mysql-8.0.17-winx64
    # 设置mysql数据库的数据的存放目录
    datadir = D:\\mysql\\mysql-8.0.17-winx64\\data
    # 允许最大连接数
    max_connections=20
    # 服务端使用的字符集默认为8比特编码的latin1字符集
    character-set-server=utf8
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 创建模式
    sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    

​ 设置mysql的安装目录

  1. 进入cmd初始化mysql

    mysqld --initialize
  2. 系统会生成一个data文件夹 打开文件夹搜索找到.err后缀的文件

  3. 找到用户名root 开头的 密码是localhost后面的字符

  4. 在管理员cmd中输入

     net start mysql
  5. 输入

    mysql -u用户名 -p密码
  6. 第一次进入修改密码

    alter user 'root'@'localhost' identified with mysql_native_password by ' **这里填写新密码** ';

mysql-'s People

Contributors

romeloran avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.