解决CentOS下mysql启动失败
今天用service mysqld start
命令启动mysql失败 查看mysql日志 tail -n 10 /var/log/mysql.log160702 04:41:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql160702 4:41:17 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.Unknown suffix ' ' used for variable 'lower_case_table_names' (value '1 //表名不区分大小写(此与编码无关)')160702 4:41:17 [ERROR] /usr/libexec/mysqld: Error while setting value '1 //表名不区分大小写(此与编码无关)' to 'lower_case_table_names'160702 4:41:17 [ERROR] Aborting160702 04:41:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
原来是之前修改配置文件惹得祸vim /etc/my.cnf
修改配置参数,修改对应的[mysqld]节点下的:lower_case_table_names=1一行 去掉多余的注释后可以正常启动 但是执行查询语句时select * from A1;报错a1 not exists; 没办法,手起刀落人抬走,dd(vim)删掉那一行,搞定! Yeah~
http://www.dengb.com/xtzh/1155917.htmlwww.dengb.comtruehttp://www.dengb.com/xtzh/1155917.htmlTechArticle解决CentOS下mysql启动失败 今天用 service mysqld start 命令启动mysql失败 查看mysql日志 tail -n 10 /var/log/mysql.log 160702 04:41:17 mysqld_safe Starting mysqld...