• mysql 5.6.17 x64 安装


    下载地址

    百度网盘地址:http://pan.baidu.com/share/link?shareid=1895747668&uk=3257050114&fid=234538452

    官网下载太慢了,擦!

    1.将 my-default.ini文件 复制一份 改为my.ini

    配置文件如下

    [WinMySQLAdmin] 
    Server=E:Mydatalymysql-5.6.15in
    
    [client]
    no-beep
    
    # pipe
    # socket=mysql
    port=3306
    
    [mysql]
    
    default-character-set=utf8
    
    # For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.6/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.
    
    [mysqld]
    
    explicit_defaults_for_timestamp = TRUE
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    innodb_buffer_pool_size = 2G
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    
    basedir="E:Mydatalymysql-5.6.15"
    datadir="E:Mydatalymydata"
    
    port=3306
    server_id=1
    
    general-log=0
    general_log_file="mysql_general.log"
    slow-query-log=1
    slow_query_log_file="mysql_slow_query.log"
    long_query_time=10
    
    log-error="mysql_error_log.err"
    
    
    default-storage-engine=INNODB
    max_connections=1024
    query_cache_size=128M
    key_buffer_size=128M
    innodb_flush_log_at_trx_commit=1
    innodb_thread_concurrency=128
    innodb_autoextend_increment=128M
    tmp_table_size=128M
    
    
    # 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 
    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    character-set-server=utf8

    2. dos 下进入mysql 安装目录 运行

    mysqld -install mysql  --default-file=E:mydatalymysql-5.6.15my.ini
  • 相关阅读:
    手写一个类django框架
    Django基础知识
    JQuery知识点总结
    javascript知识点整理
    html知识点一
    mysql之sql语句
    通过非IO阻塞模型实现ftp并发的小代码
    python学习第三十三节(IO模型)
    python学习第三十二节(进程间通信、进程池、协程)
    IntelliJ IDEA For Mac 快捷键
  • 原文地址:https://www.cnblogs.com/bugs/p/3683804.html
Copyright © 2020-2023  润新知