• 【Mysql】安装 mysql-5.7.5 指南


    • 因为同学需要安装mysql,安装过程,一路百度,在这里记录一下步奏。以后还会用到。

      1.mysql-5.7.5-m15-winx64.zip下载

         官方网站下载地址:http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.5-m15-winx64.zip 直接迅雷这个地址

      2.解压到D:MySqlDataBase

      3.在D:MySqlDataBasemysql-5.7.5-m15-winx64下新建my.ini配置文件

         内容如下:

    ####################配置文件开始###################
    
     # For advice on how to change settings please see
    
     # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    
     # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    
     # *** default location during install, and will be replaced if you
    
     # *** upgrade to a newer version of MySQL.
    
     [client]
    
     default-character-set=utf8
    
     
    
     [mysqld]
    
     port=3306
    
     basedir  ="D:MySqlDataBasemysql-5.7.5-m15-winx64/"
    
     datadir  ="D:MySqlDataBasemysql-5.7.5-m15-winx64/data/"
    
     tmpdir   ="D:MySqlDataBasemysql-5.7.5-m15-winx64/data/"
    
     socket   ="D:MySqlDataBasemysql-5.7.5-m15-winx64/data/mysql.sock"
    
     log-error="D:MySqlDataBasemysql-5.7.5-m15-winx64/data/mysql_error.log"
    
     
    
     #server_id = 2
    
     #skip-locking
    
     
    
     max_connections=100
    
     table_open_cache=256
    
     query_cache_size=1M
    
     
    
     tmp_table_size=32M
    
     thread_cache_size=8
    
     
    
     innodb_data_home_dir="D:MySqlDataBasemysql-5.7.5-m15-winx64/data/"
    
     innodb_flush_log_at_trx_commit =1
    
     innodb_log_buffer_size=128M
    
     innodb_buffer_pool_size=128M
    
     innodb_log_file_size=10M
    
     innodb_thread_concurrency=16
    
     innodb-autoextend-increment=1000
    
     join_buffer_size = 128M
    
     sort_buffer_size = 32M
    
     read_rnd_buffer_size = 32M
    
     max_allowed_packet = 32M
    
     explicit_defaults_for_timestamp=true
    
     sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    
     #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
    ####################配置文件结束###################

      4.在windows系统环境变量path,加入如下内容

          D:mysqlmysql-5.7.5-m15-winx64in;(注意加分号)

      5.打开cmd转到安装路径的bin文件加下,然后输入指令"mysqld -install"

      6.然后继续在cmd中输入指令"net start mysql" 会显示MySql服务已经启动成功

      7.在cmd中输入mysql -u root -p 就可以开始操作数据库啦

  • 相关阅读:
    hdu 3496
    poj 2374
    zoj 3399
    poj 1321
    sgu 365
    hdu 3555
    poj 3345
    poj 2355
    Android重命名文件
    在workflow中传值的sample
  • 原文地址:https://www.cnblogs.com/zhengbin/p/4605418.html
Copyright © 2020-2023  润新知