linuxでmysqlが起動できない

awsでmysqlを起動させようとしているのですができません。何度も削除して再インストールしたのですが直りません

command
1[root@ip-10-0-0-24 ~]# systemctl start mysqld
2Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
3[root@ip-10-0-0-24 ~]# journalctl -xe
4--
5-- The start-up result is done.
6Aug 26 01:40:01 ip-10-0-0-24.ap-northeast-1.compute.internal CROND[29024]: (root) CMD (/usr/lib64/sa/sa1 1 1)
7Aug 26 01:40:01 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Removed slice User Slice of root.
8-- Subject: Unit user-0.slice has finished shutting down
9-- Defined-By: systemd
10-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
11--
12-- Unit user-0.slice has finished shutting down.
13Aug 26 01:40:38 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29030]: Received disconnect from 222.187.254.38 port 52168:11:  [preauth]
14Aug 26 01:40:38 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29030]: Disconnected from 222.187.254.38 port 52168 [preauth]
15Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29032]: error: AuthorizedKeysCommand /opt/aws/bin/eic_run_authorized_keys ec2-user SHA256:HJqLb
16Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29032]: Accepted publickey for ec2-user from 111.239.187.119 port 61849 ssh2: RSA SHA256:HJqLb5
17Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Started Session 2351 of user ec2-user.
18-- Subject: Unit session-2351.scope has finished start-up
19-- Defined-By: systemd
20-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
21--
22-- Unit session-2351.scope has finished starting up.
23--
24-- The start-up result is done.
25Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal systemd-logind[2475]: New session 2351 of user ec2-user.
26-- Subject: A new session 2351 has been created for user ec2-user
27-- Defined-By: systemd
28-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
29-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/multiseat
30--
31-- A new session with the ID 2351 has been created for the user ec2-user.
32--
33-- The leading process of the session is 29032.
34Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29032]: pam_unix(sshd:session): session opened for user ec2-user by (uid=0)
35Aug 26 01:40:57 ip-10-0-0-24.ap-northeast-1.compute.internal dhclient[2751]: XMT: Solicit on eth0, interval 130700ms.
36Aug 26 01:40:59 ip-10-0-0-24.ap-northeast-1.compute.internal sudo[29176]: ec2-user : TTY=pts/0 ; PWD=/home/ec2-user ; USER=root ; COMMAND=/bin/su -
37Aug 26 01:40:59 ip-10-0-0-24.ap-northeast-1.compute.internal sudo[29176]: pam_unix(sudo:session): session opened for user root by ec2-user(uid=0)
38Aug 26 01:40:59 ip-10-0-0-24.ap-northeast-1.compute.internal su[29177]: (to root) ec2-user on pts/0
39Aug 26 01:40:59 ip-10-0-0-24.ap-northeast-1.compute.internal su[29177]: pam_unix(su-l:session): session opened for user root by ec2-user(uid=0)
40Aug 26 01:41:09 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Starting MySQL Server...
41-- Subject: Unit mysqld.service has begun start-up
42-- Defined-By: systemd
43-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
44--
45-- Unit mysqld.service has begun starting up.
46Aug 26 01:41:12 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
47Aug 26 01:41:12 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Failed to start MySQL Server.
48-- Subject: Unit mysqld.service has failed
49-- Defined-By: systemd
50-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
51--
52-- Unit mysqld.service has failed.
53--
54-- The result is failed.
55Aug 26 01:41:12 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Unit mysqld.service entered failed state.
56Aug 26 01:41:12 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: mysqld.service failed.

どうやら　opt/aws/bin/eic_run_authorized_key　ってところに問題があるらしいんですが

command
1[root@ip-10-0-0-24 ~]# cat /opt/aws/bin/eic_run_authorized_keys
2#!/bin/sh
3
4# Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
5#
6# Licensed under the Apache License, Version 2.0 (the "License"). You
7# may not use this file except in compliance with the License. A copy of
8# the License is located at
9#
10# http://aws.amazon.com/apache2.0/
11#
12# or in the "license" file accompanying this file. This file is
13# distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF
14# ANY KIND, either express or implied. See the License for the specific
15# language governing permissions and limitations under the License.
16
17# Quickie to wrap curl_authorized_keys in a timeout
18# Necessary for older versions of openssh where AuthorizedKeysCommand must be a filepath
19set -e
20DIR="$( cd "$( dirname "${0}" )" && pwd )"
21/usr/bin/timeout 5s "${DIR}/eic_curl_authorized_keys" "$@"

どうすれば解決できますか？

行動規範の内容に同意します

回答1件

ベストアンサー

こちらはsshdでのメッセージなのでmysqlは関係なさそうです

Aug 26 01:40:43 ip-10-0-0-24.ap-northeast-1.compute.internal sshd[29032]: error: AuthorizedKeysCommand /opt/aws/bin/eic_run_authorized_keys ec2-user SHA256:HJqLb

mysqlの起動はこちらのタイミングですので、この時刻以降を確認しましょう

Aug 26 01:41:09 ip-10-0-0-24.ap-northeast-1.compute.internal systemd[1]: Starting MySQL Server...

mysqlが起動しないとのことですが、下記はどうでしょうか
・インストールをどのように実施したのか不明です→インストール手順がそもそも正しいのか/間違っているのか判別できない
・インストール直後から起動できないのか？→設定変更の有無が記載されていないので設定変更のせいなのか判別できない

投稿2021/08/26 03:11

yukky1201

総合スコア2751

あなたの回答

tips

プレビュー

行動規範の内容に同意します

質問の解決につながる回答をしましょう。サンプルコードなど、より具体的な説明があると質問者の理解の助けになります。また、読む側のことを考えた、分かりやすい文章を心がけましょう。

15分調べてもわからないことは
teratailで質問しよう！

ただいまの回答率
85.48%

質問をまとめることで
思考を整理して素早く解決

テンプレート機能で
簡単に質問をまとめる

質問する

質問をすることでしか得られない、回答やアドバイスがある。

15分調べてもわからないことは、質問しよう！

linuxでmysqlが起動できない

関連した質問