首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >mysql启动失败?

mysql启动失败?

提问于 2023-01-06 14:51:35
回答 0关注 0查看 74

[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

回答

和开发者交流更多问题细节吧,去 写回答
相关文章

相似问题

相关问答用户
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档