无法打开mysql editor_MySQL初始化故障-----mysql_config_editor中的坑

最新推荐文章于 2024-09-06 09:05:33 发布

weixin_39728909

最新推荐文章于 2024-09-06 09:05:33 发布

阅读量454

点赞数

文章标签：无法打开mysql editor

本文链接：https://blog.csdn.net/weixin_39728909/article/details/113981257

版权

在CentOS 6.4上安装MySQL 5.6时遇到初始化错误，由于.mysql_config_editor创建的.mylogin.cnf文件中的设置，导致mysqld无法启动。通过删除.mylogin.cnf文件并理解其作用，成功解决问题。mysql_config_editor工具创建的.login_path为mysqld导致了主机名被错误地赋给了host_cache_size变量，修复方法是避免使用可能与MySQL参数混淆的.login_path。

摘要由CSDN通过智能技术生成

今天准备新启一个MySQL实例，结果竟然无法初始化，内容如下：

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[root@hadoop-node-2 ~]# cat /etc/issue

CentOS release 6.4 (Final)

[root@hadoop-node-2 ~]# mysql --version

./bin/mysql Ver 14.14 Distrib 5.6.24, for linux-glibc2.5 (x86_64) using EditLine wrapper

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

报错如下：

[root@hadoop-node-2 mysql56]# ./scripts/mysql_install_db --defaults-file=/data/db/mysql/3310/my.cnf

Installing MySQL system tables...2016-04-28 11:07:37 0 [Warning] Ignoring user change to 'root' because the user was set to 'mysql' earlier on the command line

2016-04-28 11:07:37 0 [Warning] Using unique option prefix host instead of host_cache_size is deprecated and will be removed in a future release. Please use the full name instead.

Unknown suffix '.' used for variable 'host_cache_size' (value '127.0.0.1')

2016-04-28 11:07:37 0 [ERROR] ./bin/mysqld: Error while setting value '127.0.0.1' to 'host_cache_size'

2016-04-28 11:07:37 0 [ERROR] Aborting

换种方法初始化，继续报错：

[root@hadoop-node-2 mysql56]# ./scripts/mysql_install_db --no-defaults --datadir=/data/db/mysql/3310