os version: Red Hat Enterprise Linux Server release 6.5 (Santiago)

mysql version: mysql5.6.34-log

安装方式:源码安装

场景:最近在初始化mysql的多实例过程种,突然遇到如下问题,初始化过程如下,在设定basedir和datadir参数后,进行数据库实例初始化时,就一直hang住了,如下,

做了如下的尝试操作:

(1) 使用root用户来进行安装;

(2) 切换数据库实例的安装目录;

[mysql@slave3 ~/mysql/scripts]./mysql_install_db --basedir=/home/mysql/mysql/ --datadir=/mnt/data6/mysqldata2/mydata
Installing MySQL system tables...2016-10-27 10:56:34 0 [Warning] Using unique option prefix collation instead of collation-server is deprecated and will be removed in a future release. Please use the full name instead.
2016-10-27 10:56:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-27 10:56:34 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2016-10-27 10:56:34 0 [Note] /home/mysql/mysql//bin/mysqld (mysqld 5.6.34-log) starting as process 55964 ...
2016-10-27 10:56:34 55964 [Warning] Using pre 5.5 semantics to load error messages from /home/mysql/mysql/share/english/.
2016-10-27 10:56:34 55964 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.


额外还尝试了其它多种方法,但是都不实用,起初有怀疑是不是限制了磁盘配额,但是并不是。

直到最后,初始化都仅仅是在/mnt/data6/mysqldata2/mydata目录下建立了2个文件件,mysql, test


原因:直到现在也不清楚


解决方法:./mysql_install_db --basedir=/home/mysql/mysql/ --datadir=/mnt/data6/mysqldata2/mydata --no-defaults 

GitHub 加速计划 / li / linux-dash
10
2
下载
A beautiful web dashboard for Linux
最近提交(Master分支:8 天前 )
186a802e added ecosystem file for PM2 5 年前
5def40a3 Add host customization support for the NodeJS version 5 年前
Logo

旨在为数千万中国开发者提供一个无缝且高效的云端环境,以支持学习、使用和贡献开源项目。

更多推荐