mysql启动报错Can't read from messagefile处理
来源:互联网 发布:淘宝砖石展位教程 编辑:程序博客网 时间:2024/06/01 09:25
一.基本信息
版本:mysql 5.6.29
事务级别:RC
二进制格式:ROW
二.问题描述
启动mysql时报错:
[mysql@mvxl0783 ~]$ /opt/mysql/mysql-5.6.29-linux-glibc2.5-x86_64/bin/mysqld --defaults-file=/data/mysql/mysql3377/my3377.cnf &
[1] 24679
[mysql@mvxl0783 ~]$ 2016-06-09 16:49:15 0 [Note] /opt/mysql/mysql-5.6.29-linux-glibc2.5-x86_64/bin/mysqld (mysqld 5.6.29-log) starting as process 24679 ...
2016-06-09 16:49:15 24679 [ERROR] Can't read from messagefile '/apps/svr/mariadb101/share/english/errmsg.sys'
三.问题分析
由于我是使用二进制分发包进行安装的,而默认的情况下,mysql会到/usr/local/mysql/share/english下查找该文件,但由于该主机上同时还存在mariadb实例,/usr/local/mysql目录已给mariadb占用.
四.问题处理
所以在配置文件中加入:
vi /data/mysql/mysql3377/my3377.cnf
[mysqld]
language = /opt/mysql/mysql-5.6.29-linux-glibc2.5-x86_64/share/english
再启动mysql不再报错。
- mysql启动报错Can't read from messagefile处理
- 启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys
- mysql启动错误: [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
- Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
- SQLiteException: Can't upgrade read-only database from version 0 to 1报错!
- 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报错“ you can't specify the target table for ‘update’ in from clause”
- MySql报错: You can't specify target table 'table name' for update in FROM clause
- MySQL 修改报错 You can't specify target table 'tb_trade' for update in FROM clause
- mysql报错You can't specify target table 'b' for update in FROM clause
- mysql无法启动,报错 Can't start server: can't create PID file: No space left on device
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mac os mysql启动报错 Can't open the mysql.plugin table
- 启动mysql报错Can't find file: './mysql/plugin.frm'
- web服务连接mysql报错 解析:Can not read response from server. Expected to read 4 bytes, read 0 bytes before c
- Hadoop基本操作命令
- TableView与TableViewCell
- 电商之梳理IE浏览器相关知识---浏览器
- 电商之梳理谷歌google浏览器相关知识---浏览器
- 电商之梳理hive相关知识---数据仓库工具
- mysql启动报错Can't read from messagefile处理
- 电商之梳理eclipse相关知识---开发工具
- 运行时类型识别(RTTI)
- Duplicate sources error
- 电商之梳理MyEclipse相关知识---开发工具
- 软链接和硬链接详解
- 慎重使用全局变量
- 记第一次参赛
- 问题解决:ViewPager+ViewPagerIndictor联动怎么懒加载