admin 发表于 2019-9-28 15:50:03

[ERROR] The data directory needs to be specified.

3、生成授权表

/opt/modules/mysql/bin   mysql_install_db

执行: ./mysql_install_db --user=mysql

报错:

1、   The data directory needs to be specified.

指定了数据目录 --datadir=/opt/modules/mysql/data/

继续报错:The data directory '/opt/modules/mysql/data/' already exist and is not empty.

改回之前,完整的报错:

mysql_install_db is deprecated.Please consider switching to mysqld --initialize
The data directory needs to be specified.

大概意思: mysql_install_db 已经不再推荐使用了,建议改成 mysqld –initialize 完成实例初始化

改为:./mysqld --user=mysql --datadir=/opt/modules/mysql/data/ --basedir=/opt/modules/mysql

有报错

Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
Unable to setup unix socket lock file.
Aborting

目录不存在或者权限不足,所以我们直接使用命令

mkdir -p /var/log/mysql/      创建目录

chown -R mysql:mysql /var/log/mysql/   设置权限

重新执行:./mysqld --user=mysql --datadir=/opt/modules/mysql/data/ --basedir=/opt/modules/mysql
页: [1]
查看完整版本: [ERROR] The data directory needs to be specified.