初始化vba库65535出错_======[已解决]MySQL5.6.17初始化数据库出错，请帮忙！=====

最新推荐文章于 2023-03-09 14:24:14 发布

weixin_39535125

最新推荐文章于 2023-03-09 14:24:14 发布

阅读量363

点赞数

文章标签：初始化vba库65535出错

本文链接：https://blog.csdn.net/weixin_39535125/article/details/111813159

版权

在尝试初始化MySQL 5.6.17时遇到错误'Can't read from messagefile '/usr/share/mysql/errmsg.sys''。尽管文件权限正确，但安装过程中似乎存在问题。错误出现在安装步骤的'scripts/mysql_install_db'阶段，导致数据库启动失败。日志显示InnoDB初始化完成，但在启动时遇到错误并终止。

摘要由CSDN通过智能技术生成

本帖最后由奋斗的毛毛虫于 2014-05-23 16:14 编辑

root@clbus:/usr/local/mysql# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

Installing MySQL system tables...2014-05-23 11:12:48 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.

2014-05-23 11:12:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2014-05-23 11:12:48 24390 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/mysql/.

2014-05-23 11:12:48 24390 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.

2014-05-23 11:12:48 24390 [ERROR] Can't read from messagefile '/usr/share/mysql/errmsg.sys'

2014-05-23 11:12:48 24390 [Note] InnoDB: Using atomics to ref count buffer pool pages

2014-05-23 11:12:48 24390 [Note] InnoDB: The InnoDB memory heap is disabled

2014-05-23 11:12:48 24390 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2014-05-23 11:12:48 24390 [Note] InnoDB: Compressed tables use zlib 1.2.3

2014-05-23 11:12:48 24390 [Note] InnoDB: Not using CPU crc32 instructions

2014-05-23 11:12:48 24390 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2014-05-23 11:12:48 24390 [Note] InnoDB: Completed initialization of buffer pool

2014-05-23 11:12:48 24390 [Note] InnoDB: Highest supported file format is Barracuda.

2014-05-23 11:12:48 24390 [Note] InnoDB: 128 rollback segment(s) are active.

2014-05-23 11:12:48 24390 [Note] InnoDB: Waiting for purge to start

2014-05-23 11:12:48 24390 [Note] InnoDB: 5.6.17 started; log sequence number 1600607

2014-05-23 11:12:48 24390 [ERROR] Aborting

2014-05-23 11:12:48 24390 [Note] Binlog end

2014-05-23 11:12:48 24390 [Note] InnoDB: FTS optimize thread exiting.

2014-05-23 11:12:48 24390 [Note] InnoDB: Starting shutdown...

2014-05-23 11:12:50 24390 [Note] InnoDB: Shutdown completed; log sequence number 1600617

2014-05-23 11:12:50 24390 [Note]

---------------------------------------------------->

2014-05-23 11:12:48 24390 [ERROR] Can't read from messagefile '/usr/share/mysql/errmsg.sys'

root@clbus:/usr/local/mysql# ls -ld /usr/share/mysql/

drwxr-xr-x 2 mysql mysql 4096 May 22 12:32 /usr/share/mysql/

root@clbus:/usr/local/mysql# ls -lh /usr/share/mysql/errmsg.sys

-rwxr-xr-x 1 mysql mysql 0 May 22 12:32 /usr/share/mysql/errmsg.sys

文件权限没有问题呀。

之前安装过程：

tar zxvf mysql-5.6.14.tar.gz

cd mysql-5.6.14

apt-get update

apt-get install bison

apt-get ncurses-devel

cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_ARCHIVE_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DMYSQL_TCP_PORT=3306 \

-DENABLE_DOWNLOADS=0

make

make install

groupadd mysql

useradd -g mysql mysql

chown -R mysql.mysql /usr/local/mysql/

ls -lh /usr/local/mysql/

scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data