找回 MySQL root 密码的时候出错

2014-10-31 12:02:21 +08:00
 iugo
阿里云, CentOS. 我觉得这个问题主要出在「 MySQL 的安装目录不是默认目录」.
我修改了 mysql-5.5.37/bin/mysqld_safe 文件, 但还是出现了目录错误.
如何解决, 请指教. 谢谢.

# service mysqld stop

Shutting down MySQL. SUCCESS!

# mysqld_safe --skip-grant-tables --skip-networking &

[1] 1364
[root@centos ~]# 141031 11:51:51 mysqld_safe Logging to 'mysql/error.log'.
141031 11:51:51 mysqld_safe Starting mysqld daemon with databases from mysql-5.5.37/data
141031 11:51:53 mysqld_safe mysqld from pid file mysql-5.5.37/data/iZ28w1otkcfZ.pid ended
[1]+ Done

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

错误信息大概是这样的:

141031 11:51:52 InnoDB: Starting shutdown...
141031 11:51:53 InnoDB: Shutdown completed; log sequence number 5400240
141031 11:51:53 [Note]
141031 11:51:53 mysqld_safe mysqld from pid file mysql-5.5.37/data/iZ28w1otkcfZ.pid ended
141031 11:52:32 mysqld_safe Starting mysqld daemon with databases from mysql-5.5.37/data


141031 11:52:32 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'


141031 11:52:32 [Note] Plugin 'FEDERATED' is disabled.
141031 11:52:32 InnoDB: The InnoDB memory heap is disabled
141031 11:52:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141031 11:52:32 InnoDB: Compressed tables use zlib 1.2.3
141031 11:52:32 InnoDB: Using Linux native AIO
141031 11:52:32 InnoDB: Initializing buffer pool, size = 128.0M
141031 11:52:32 InnoDB: Completed initialization of buffer pool
141031 11:52:32 InnoDB: highest supported file format is Barracuda.
141031 11:52:32 InnoDB: Waiting for the background threads to start
141031 11:52:33 InnoDB: 5.5.37 started; log sequence number 5400240
141031 11:52:33 [ERROR] Aborting
2007 次点击
所在节点    问与答
0 条回复

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/142872

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX