[ERROR] The data directory needs to be specified.

admin

3、生成授权表

2 `! ?+ A9 \+ }, A/opt/modules/mysql/bin   mysql_install_db

执行： ./mysql_install_db --user=mysql

报错：
8 x2 }" H( a5 J3 j- Y
) T. ~" H; |& ~0 O: m1、[ERROR]   The data directory needs to be specified.

指定了数据目录 --datadir=/opt/modules/mysql/data/
  T/ s" P$ z( V; ?# [
继续报错：The data directory '/opt/modules/mysql/data/' already exist and is not empty.
* w+ a: x, q. [, q
改回之前，完整的报错：
2 K/ [; i: X  E3 t
[WARNING]mysql_install_db is deprecated.Please consider switching to mysqld --initialize
6 ^, z$ U( T$ s3 X% O, }9 @[ERROR] The data directory needs to be specified.
- |1 V% t9 O' B) }, U1 n+ x/ h
% l( l3 j& ?$ }6 L3 ^- t1 W大概意思： mysql_install_db 已经不再推荐使用了，建议改成 mysqld –initialize 完成实例初始化

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

  j# l3 Z) X/ \+ P- ^8 A有报错
; y& \" E2 g! ?: `9 h
[ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
[ERROR] Unable to setup unix socket lock file.
! N9 V+ g3 l- P9 o[ERROR] Aborting

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

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

4 M& _, s# `% l4 {chown -R mysql:mysql /var/log/mysql/     设置权限

3 a$ K! c1 j6 n4 ?. s) ?重新执行：./mysqld --user=mysql --datadir=/opt/modules/mysql/data/ --basedir=/opt/modules/mysql