mysql启动错误: [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
来源:互联网 发布:淘宝专修 编辑:程序博客网 时间:2024/06/08 07:53
我的mysql是安装在/usr/local/mysql目录下,bin/mysqld_safe --user=mysql &启动后,从日志文件中发现如下错误:
- 110623 21:49:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
- 110623 21:49:41 [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
- 110623 21:49:41 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
- 110623 21:49:41 [Warning] Can't create test file /var/lib/mysql/ubuntu.lower-test
- /usr/local/mysql/bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
- 110623 21:49:41 [ERROR] Aborting
从日志上发现,mysql的启动目录不对。
修改启动命令:
sudo mysqld_safe --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql &
即可启动成功:
110623 21:49:41 [Note]
110623 21:49:41 mysqld_safe mysqld from pid file /var/lib/mysql/ubuntu.pid ended
110623 21:57:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data/
110623 21:57:21 InnoDB: The InnoDB memory heap is disabled
110623 21:57:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110623 21:57:21 InnoDB: Compressed tables use zlib 1.2.3.3
110623 21:57:21 InnoDB: Initializing buffer pool, size = 128.0M
110623 21:57:21 InnoDB: Completed initialization of buffer pool
110623 21:57:21 InnoDB: highest supported file format is Barracuda.
110623 21:57:21 InnoDB: Waiting for the background threads to start
110623 21:57:22 InnoDB: 1.1.7 started; log sequence number 1607993
110623 21:57:22 [Note] Event Scheduler: Loaded 0 events
110623 21:57:22 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.13' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution
- mysql启动错误: [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
- Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
- Mysql 5.6 [error] Can't find messagefile '/usr/share/mysql/errmsg.sys'
- 启动mysql出错:Can't find messagefile '/usr/share/mysql/errmsg.sys
- [ERROR] Can't find messagefile '/usr/bin/share/mysql/errmsg.sys'
- Mysql 5.6 Can't find messagefile '/usr/share/mysql/errmsg.sys'解决方法
- [ERROR] Can't find messagefile '/var/lib/mysql/share/errmsg.sys'(转载)
- mysql启动报错Can't read from messagefile处理
- 安装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
- 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
- freebsd8.0安装nvidia驱动出现"/usr/share/mk/bsd.kmod.mk", line 12: "can't find kernel source tree"错误,解决办法
- Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)
- mysql错误Error(1133): Can’t find any matching row in the use
- oracle中 all any in的用法
- struts2中文乱码解决方法 (转载)
- 重载运算符后的返回值?
- glibc之数据类型定义分析
- nm命令中符号类型详解
- mysql启动错误: [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
- Epub格式电子书格式
- IO 文件的读取
- ruby多线程编程(实例)
- DiscuzX2用户同步PHP代码
- 9 个开发人员应该知道的 PHP 库
- jquery的200多个插件
- 详细解析ASP.NET中Request接收参数乱码原理
- 网站地址整理