Vultr 우분투에서 mysql 설정 중인데 restart만 하면 에러가 뜸. 무슨 문제임? 호스트는 다른 이름인데 혹시 몰라서 test/test.kr로 바꿔서 올림


root@test:~# service mysql restart
Job for mysql.service failed because a fatal signal was delivered to the control process.
See "systemctl status mysql.service" and "journalctl -xe" for details.


root@test:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: signal) since Fri 2020-11-27 18:18:06 KST; 6min ago
    Process: 23425 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=killed, signal=TERM)

Nov 27 18:18:06 test.kr systemd[1]: Starting MySQL Community Server...
Nov 27 18:18:06 test.kr systemd[1]: mysql.service: Control process exited, code=killed, status=15/TERM
Nov 27 18:18:06 test.kr systemd[1]: mysql.service: Failed with result 'signal'.
Nov 27 18:18:06 test.kr systemd[1]: Stopped MySQL Community Server.
Nov 27 18:18:06 test.kr systemd[1]: mysql.service: Start request repeated too quickly.
Nov 27 18:18:06 test.kr systemd[1]: mysql.service: Failed with result 'signal'.
Nov 27 18:18:06 test.kr systemd[1]: Failed to start MySQL Community Server.

(error.log)
2020-11-27T09:18:03.670263Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.22-0ubuntu0.20.10.2)  (Ubuntu).
2020-11-27T09:18:04.368839Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22-0ubuntu0.20.10.2) starting as process 23383
2020-11-27T09:18:04.377198Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-11-27T09:18:04.569958Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-11-27T09:18:04.669674Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-11-27T09:18:04.729023Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-11-27T09:18:04.729157Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-11-27T09:18:04.732349Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_type=ON'.
2020-11-27T09:18:04.732656Z 0 [ERROR] [MY-010119] [Server] Aborting


따라한건 blog.lael.be/post/7264 이거