• Starting MySQL...The server quit without updating PID file [失败]local/mysql/data/localhost.localdomain.pid报错


    在添加命令自动补全的时候mysql启动失败

    这是原配

      1 # For advice on how to change settings please see
      2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
      3 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
      4 # *** default location during install, and will be replaced if you
      5 # *** upgrade to a newer version of MySQL.
      6 
      7 [mysqld]
      8 
      9 # Remove leading # and set to the amount of RAM for the most important data
     10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
     11 # innodb_buffer_pool_size = 128M
     12 
     13 # Remove leading # to turn on a very important data integrity option: logging
     14 # changes to the binary log between backups.
     15 # log_bin
     16 
     17 # These are commonly set, remove the # and set as required.
     18 # basedir = .....
     19 # datadir = .....
     20 # port = .....
     21 # server_id = .....
     22 # socket = .....
     23 
     24 # Remove leading # to set options mainly useful for reporting servers.
     25 # The server defaults are faster for transactions and fast SELECTs.
     26 # Adjust sizes as needed, experiment to find the optimal values.
     27 # join_buffer_size = 128M
     28 # sort_buffer_size = 2M
     29 # read_rnd_buffer_size = 2M
     30 
     31 
     32 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
     33 
    View Code

    就是什么都注释掉了, 后来加上一行

    auto-rehash

    启动报错

    QQ截图20170724164228

    这是什么问题, 百度谷歌人家都能用这个配置, 我这里就不行..., 求解决

  • 相关阅读:
    1_Flask开启debug
    29_使用celery发送短信
    00_celery介绍(处理耗时任务)
    28_django限制请求方法装饰器
    27_扩展User模型
    05-3_单链表的实现
    05-2_单向链表
    05-1_链表的定义
    04-2_Python中的线性表
    04-1_线性表的操作
  • 原文地址:https://www.cnblogs.com/chenglee/p/7230016.html
Copyright © 2020-2023  润新知