启动mysql出错：Can't find messagefile '/usr/share/mysql/errmsg.sys

发布:smiling　来源: PHP粉丝网　添加日期：2015-04-17 17:16:02　浏览: 评论：0　

下面我们来看看关于启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys出错问题的解决办法吧.

启动数据库出现错误,错误信息是:

[ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

root@debian:/usr/local# /etc/init.d/mysql3306 start

Starting MySQL

...The server quit without updating PID file (/home/www/mysql/m3306/mysql3306.pid). ... failed!

root@debian:/usr/local/mysql3306# cat /home/www/mysql/m3306/mysql3306.err

120102 14:11:58 mysqld_safe Starting mysqld daemon with databases from /home/www/mysql/m3306

120102 14:11:58 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

120102 14:11:58 [Note] Plugin 'FEDERATED' is disabled.

120102 14:11:58 InnoDB: The InnoDB memory heap is disabled

120102 14:11:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins

120102 14:11:58 InnoDB: Compressed tables use zlib 1.2.3

120102 14:11:58 InnoDB: Using Linux native AIO

120102 14:11:58 InnoDB: Initializing buffer pool, size = 128.0M

120102 14:11:58 InnoDB: Completed initialization of buffer pool

120102 14:11:58 InnoDB: highest supported file format is Barracuda.

120102 14:11:58  InnoDB: Waiting for the background threads to start

120102 14:11:59 InnoDB: 1.1.8 started; log sequence number 1595675  --phpfensi.com

120102 14:11:59 [ERROR] Aborting

120102 14:11:59  InnoDB: Starting shutdown...

120102 14:12:00  InnoDB: Shutdown completed; log sequence number 1595675

120102 14:12:00 [Note]

120102 14:12:00 mysqld_safe mysqld from pid file /home/www/mysql/m3306/mysql3306.pid ended

解决方法是:

root@debian:/usr/local# vi mysql3306/my.cnf

加入language配置项,由于我是使用二进制分发包进行安装的,而默认的情况下,mysql会到/usr/local/mysql/share/english下查找该文件,但由于我的mysql安装路径为/usr/local/mysql3306/,所以如下:

[mysqld]

pid-file = /home/www/mysql/m3306/mysql3306.pid

log-error = /home/www/mysql/m3306/mysql3306.err

language = /usr/local/mysql3306/share/english #此处为language配置项

port = 3306

socket = /tmp/mysql3306.sock

basedir = /usr/local/mysql3306

datadir = /home/www/mysql/m3306

重新启动:

root@debian:/usr/local# /etc/init.d/mysql3306 start

Starting MySQL

已成功启动.

Tags: Can t find messagefile usr

分享到：

上一篇：Mac OS X 上 MySQL 提示 “MySQLWorkbench quit unexpectly.”解决办法
下一篇：解决#2006 - MySQL server has gone away错误

·Mysql出现Can’t connect to MySQL server on ‘localhost’ (10061)问题(2014-09-23)
·mysql删除数据提示Cannot delete or update(2014-09-24)
·解决Navicat cannot proceed because system tables办法(2014-09-24)
·MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误(2014-09-27)
·Can't create/write to file C:/WINDOWS/TEMP/...MYSQL (2014-09-29)
·mysql提示Can't find messagefile /usr/share/mysql/english/errmsg.sys(2014-10-04)
·启动MYSQL提示:Can’t connect to MySQL through socket ‘/tmp/mysql.sock(2014-10-08)
·mysql提示Can t connect to MySQL server on localhost (10061)(2014-10-09)
·MySQL报错1042-Can t get hostname for your address(2014-10-10)
·MySQL报错1042-Can't get hostname for your address(2014-10-10)
·mysql恢复数据数据出现Variable sql_mode cant 解决方法(2014-10-10)
·mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication(2014-10-13)
·mysql Can’t connect to local MySQL server through socket ‘/var/lib/mysql/(2014-10-14)
·Navicat 导出mysql数据库的时候出现 “Cannot proceed because system(2015-04-18)
·解决mysqlnd cannot connect to MySQL 4.1+ using the old insec(2015-04-20)
·怎样使MySQL安全以对抗解密高手(2013-11-11)

启动mysql出错：Can't find messagefile '/usr/share/mysql/errmsg.sys

发布:smiling　来源: PHP粉丝网　添加日期：2015-04-17 17:16:02　浏览: 评论：0

Tags: Can t find messagefile usr

分享到：

相关文章

推荐文章

热门文章

最新评论文章

启动mysql出错：Can't find messagefile '/usr/share/mysql/errmsg.sys

发布:smiling 来源: PHP粉丝网 添加日期：2015-04-17 17:16:02 浏览: 评论：0

Tags: Can t find messagefile usr

相关文章

推荐文章

热门文章

最新评论文章

发布:smiling　来源: PHP粉丝网　添加日期：2015-04-17 17:16:02　浏览: 评论：0　