问题描述 : 阿里云centos安装mysql5.6出现下面错误,有没有可提供解决参考方案
请教社区的大神
[admin@izbp12hx8zhd9bnyuhqumez mysql]$ sudo bin/mysqld --initialize --user=mysql
2018-10-12 19:16:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-10-12 19:16:48 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-10-12 19:16:48 0 [Note] bin/mysqld (mysqld 5.6.41) starting as process 371 ...
2018-10-12 19:16:48 371 [Warning] Can't create test file /var/lib/mysql/izbp12hx8zhd9bnyuhqumez.lower-test
2018-10-12 19:16:48 371 [Warning] Can't create test file /var/lib/mysql/izbp12hx8zhd9bnyuhqumez.lower-test
bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2 - No such file or directory)
2018-10-12 19:16:48 371 [ERROR] Aborting
2018-10-12 19:16:48 371 [Note] Binlog end
2018-10-12 19:16:48 371 [Note] bin/mysqld: Shutdown complete
2018-10-12 19:33:50
/var/lib/下确实没有mysql这个目录,难道要自己手动创建,感觉不太科学
而且自己手动创建的缺少这个sock文件socket=/var/lib/mysql/mysql.sock
分享数据库前沿,解构实战干货,推动数据库技术变革