Starting MySQL...The server quit without updating PID file [失败]local/mysql/data/localhost.localdomai...

在添加命令自动补全的时候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

启动报错

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

转载于:https://www.cnblogs.com/chenglee/p/7230016.html