[ghc@0002 etc]$ sudo vi my.cnf
[sudo] password for ghc:
[ghc@0002 etc]$ sudo chmod 777 /export/data/mysql
chmod: cannot access '/export/data/mysql': No such file or directory
[ghc@0002 etc]$ sudo mkdir -p /export/data/mysql
[ghc@0002 etc]$ sudo chmod 777 /export/data/mysql
[ghc@0002 etc]$ /usr/local/mysql/bin/mysqld
2023-01-06T06:36:46.720454Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-01-06T06:36:46.720525Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2023-01-06T06:36:46.720547Z 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.7.27-log) starting as process 1227704 ...
2023-01-06T06:36:46.722035Z 0 [Warning] Can't create test file /data/mysql/data/0002.lower-test
2023-01-06T06:36:46.722048Z 0 [Warning] Can't create test file /data/mysql/data/0002.lower-test
mysqld: File '/data/mysql/data/mysql-bin.index' not found (Errcode: 13 - Permission denied)
2023-01-06T06:36:46.722334Z 0 [ERROR] Aborting
2023-01-06T06:36:46.722345Z 0 [Note] Binlog end
2023-01-06T06:36:46.722385Z 0 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
[ghc@0002 etc]$ sudo chmod 777 /data/mysql/data/mysql-bin.index
chmod: cannot access '/data/mysql/data/mysql-bin.index': No such file or directory
[ghc@0002 etc]$ sudo mkdir -p /data/mysql/data/mysql-bin.index
[ghc@0002 etc]$ sudo chmod 777 /data/mysql/data/mysql-bin.index
[ghc@0002 etc]$ mysqld
2023-01-06T06:39:27.221068Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-01-06T06:39:27.221142Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2023-01-06T06:39:27.221165Z 0 [Note] mysqld (mysqld 5.7.27-log) starting as process 1227827 ...
2023-01-06T06:39:27.222700Z 0 [Warning] Can't create test file /data/mysql/data/0002.lower-test
2023-01-06T06:39:27.222714Z 0 [Warning] Can't create test file /data/mysql/data/0002.lower-test
mysqld: File '/data/mysql/data/mysql-bin.index' not found (Errcode: 21 - Is a directory)
2023-01-06T06:39:27.223015Z 0 [ERROR] Aborting
2023-01-06T06:39:27.223026Z 0 [Note] Binlog end
2023-01-06T06:39:27.223069Z 0 [Note] mysqld: Shutdown complete
相似问题