使用mysql_secure_installation时出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket

mysql 5.7中mysql_secure_installation 可以使用--socket 参数指定socket文件位置了

mysql在修改data_dir之后，运行mysql_secure_installation会报如下错误

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

解决方法：

     修改mysql_secure_installation文件，大约150行，在sub make_config定义中加入 "socket=/data/mysql/mysql.sock"，修改完成如下

sub make_config {

  my $password = shift;

  my $esc_pass = basic_single_escape($rootpass);

  write_file($config,

             "# mysql_secure_installation config file",

             "[mysql]",

             "user=root",

             "password='$esc_pass'",

             "connect-expired-password",

             "socket=/data/mysql/mysql.sock");

}