[ERROR] The data directory needs to be specified.

admin

3、生成授权表

; Y* y% i3 [; U( T& m. C7 x/opt/modules/mysql/bin   mysql_install_db
; X1 c  Y0 P7 Z6 j
执行： ./mysql_install_db --user=mysql

- ~" K- ~- @3 h% \6 B* G& i报错：

  |; Q  e2 `0 t1、[ERROR]   The data directory needs to be specified.
, s1 z1 t; Q, K; C
1 ^2 x1 P2 h* U, R- x8 P指定了数据目录 --datadir=/opt/modules/mysql/data/

; X+ i: b0 ]/ o继续报错：The data directory '/opt/modules/mysql/data/' already exist and is not empty.
( v4 _* m. u! m: ?& i$ _, h
) q+ U4 l, v( b# y改回之前，完整的报错：

[WARNING]mysql_install_db is deprecated.Please consider switching to mysqld --initialize
" T# E- v( K5 c7 Z3 ~[ERROR] The data directory needs to be specified.
8 l, ]! c: o3 q# e- L1 ]' _1 ]
: Z, i8 j  E* @* O+ `大概意思： mysql_install_db 已经不再推荐使用了，建议改成 mysqld –initialize 完成实例初始化
0 q3 p) {$ W6 F5 x- C5 \
改为：./mysqld --user=mysql --datadir=/opt/modules/mysql/data/ --basedir=/opt/modules/mysql
5 i/ }9 \% A5 C8 v* x
  m0 L, y8 z5 r8 K2 N  g8 v# C0 s  U有报错

[ERROR] Could not create unix socket lock file /var/lib/mysql/mysql.sock.lock.
[ERROR] Unable to setup unix socket lock file.
( ]9 e9 F) Z) q# u, T" Y  w2 Q[ERROR] Aborting
" _$ |4 q0 G$ a& j, ?; Q. c5 o
目录不存在或者权限不足，所以我们直接使用命令

! C5 k3 O1 r, `mkdir -p /var/log/mysql/      创建目录

) v2 @7 _7 n! R! Xchown -R mysql:mysql /var/log/mysql/     设置权限
$ J, L( s" w* F" J
( [" `- T& n9 P. s) n* r重新执行：./mysqld --user=mysql --datadir=/opt/modules/mysql/data/ --basedir=/opt/modules/mysql