启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys
来源:互联网 发布:c盘中windows.old 编辑:程序博客网 时间:2024/06/08 00:37
面我们来看看关于启动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
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
...
已成功启动。
- 启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys
- Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
- mysql启动错误: [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
- Mysql 5.6 Can't find messagefile '/usr/share/mysql/errmsg.sys'解决方法
- Mysql 5.6 [error] Can't find messagefile '/usr/share/mysql/errmsg.sys'
- [ERROR] Can't find messagefile '/usr/bin/share/mysql/errmsg.sys'
- [ERROR] Can't find messagefile '/var/lib/mysql/share/errmsg.sys'(转载)
- mysql启动报错Can't read from messagefile处理
- linux安装mysql出错( file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.31-2.el6.i6)
- linux安装mysql出错( file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.31-2.el6.i6)
- linux安装mysql出错( file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.31-2.el6.i6)
- linux安装mysql出错( file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.31-2.el6.i6)
- Cento安装mysql出错 file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.5.31-2.el6.i6
- 安装mysql时报错:mysql file /usr/share/mysql/czech/errmsg.sys from install of MySQL-serve的问题
- Done with "file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.9-1.el6
- Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)
- Fuck MySQL (3) Ubuntu下mysql无法启动Couldn't find MySQL server (/usr/bin/mysqld_safe)”
- /usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
- 食屎啦你
- 简单脚本获取元素笔记
- Android5.0 Activity的跳转动画
- tensorflow MLP
- 143. Reorder List
- 启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys
- react native ios打包到真机
- 学习C++ primer plus 第9章编程练习1
- 数据挖掘-Iris数据集分析-决策边界(六)
- InfoGAN论文笔记+源码解析
- PLSQL Package Initialize Block
- removeEventListener('2016');
- 模型评估与选择
- 37-2-3