Здравствуйте! Перестал запускаться mysql после внесения правок в my.cnf, добавил там 2 строчки, и после этого их убрал. При попытке старта проц грузит до 100%, RAM до 93%, и откатывается обратно. Помогите решить проблему, не понимаю что мне нужно сделать, что это запустилось, в администрировании я не очень хорош
root@another:~# systemctl start mysql
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@another:~# 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 Tue 2023-10-10 15:50:00 MSK; 36s ago
Process: 1908964 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCE>
Process: 1908972 ExecStart=/usr/sbin/mysqld (code=killed, signal=KILL)
Main PID: 1908972 (code=killed, signal=KILL)
Status: "Server startup in progress"
Oct 10 15:49:59 another.world systemd[1]: mysql.service: Main process exited, code=killed, status=9/KILL
Oct 10 15:49:59 another.world systemd[1]: mysql.service: Failed with result 'signal'.
Oct 10 15:49:59 another.world systemd[1]: Failed to start MySQL Community Server.
Oct 10 15:50:00 another.world systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Oct 10 15:50:00 another.world systemd[1]: Stopped MySQL Community Server.
Oct 10 15:50:00 another.world systemd[1]: mysql.service: Start request repeated too quickly.
Oct 10 15:50:00 another.world systemd[1]: mysql.service: Failed with result 'signal'.
Oct 10 15:50:00 another.world systemd[1]: Failed to start MySQL Community Server.
root@another:~# journalctl -xe
Oct 10 15:51:27 another.world systemd[1]: mysql.service: Scheduled restart job, restart counter is at 4.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Oct 10 15:51:27 another.world systemd[1]: Stopped MySQL Community Server.
-- Subject: A stop job for unit mysql.service has finished
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A stop job for unit mysql.service has finished.
--
-- The job identifier is 442111 and the job result is done.
Oct 10 15:51:27 another.world systemd[1]: Starting MySQL Community Server...
-- Subject: A start job for unit mysql.service has begun execution
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit mysql.service has begun execution.
--
-- The job identifier is 442111
dmesg
[8560638.743376] [1889882] 0 1889882 179994 717 114688 0 0 snap
[8560638.743379] [1889935] 0 1889935 83529 6193 143360 0 0 python3.8
[8560638.743381] [1894593] 0 1894593 3476 681 73728 0 0 sshd
[8560638.743384] [1894786] 0 1894786 1471 527 49152 0 0 sftp-server
[8560638.743386] [1894889] 0 1894889 83529 5575 155648 0 0 python3.8
[8560638.743388] [1894950] 0 1894950 7909 4421 98304 0 0 python3.8
[8560638.743390] [1898248] 0 1898248 83529 5875 143360 0 0 python3.8
[8560638.743392] [1905350] 33 1905350 55792 4603 204800 0 0 apache2
[8560638.743395] [1905719] 0 1905719 3477 586 65536 0 0 sshd
[8560638.743397] [1905814] 0 1905814 1471 318 49152 0 0 sftp-server
[8560638.743400] [1906212] 0 1906212 6233 2491 86016 0 0 python3.8
[8560638.743402] [1906477] 0 1906477 329857 2958 233472 0 -900 snapd
[8560638.743405] [1906530] 0 1906530 83529 5611 143360 0 0 python3.8
[8560638.743407] [1907985] 0 1907985 3476 594 65536 0 0 sshd
[8560638.743409] [1908106] 0 1908106 2077 678 53248 0 0 bash
[8560638.743412] [1908259] 0 1908259 5457 1469 77824 0 0 vim
[8560638.743414] [1908554] 0 1908554 137600 935 663552 0 0 journalctl
[8560638.743417] [1908555] 0 1908555 1492 567 53248 0 0 pager
[8560638.743419] [1909036] 0 1909036 2320 662 53248 0 0 systemctl
[8560638.743422] [1909037] 0 1909037 1532 501 49152 0 0 pager
[8560638.743424] [1909172] 0 1909172 137159 958 626688 0 0 journalctl
[8560638.743426] [1909173] 0 1909173 1492 536 57344 0 0 pager
[8560638.743429] [1909692] 0 1909692 5517 453 57344 0 0 systemd-udevd
[8560638.743431] [1909693] 0 1909693 5517 469 57344 0 0 systemd-udevd
[8560638.743433] [1909694] 0 1909694 5517 453 57344 0 0 systemd-udevd
[8560638.743436] [1909695] 0 1909695 5517 437 57344 0 0 systemd-udevd
[8560638.743438] [1909696] 0 1909696 5517 437 57344 0 0 systemd-udevd
[8560638.743440] [1909697] 0 1909697 5517 371 57344 0 0 systemd-udevd
[8560638.743442] [1909698] 0 1909698 5517 418 57344 0 0 systemd-udevd
[8560638.743445] [1909699] 0 1909699 5517 408 57344 0 0 systemd-udevd
[8560638.743447] [1909700] 0 1909700 5517 371 57344 0 0 systemd-udevd
[8560638.743449] [1909701] 0 1909701 5517 379 57344 0 0 systemd-udevd
[8560638.743451] [1909703] 0 1909703 5517 397 57344 0 0 systemd-udevd
[8560638.743454] [1909704] 0 1909704 5517 394 57344 0 0 systemd-udevd
[8560638.743456] [1909705] 0 1909705 5517 379 57344 0 0 systemd-udevd
[8560638.743458] [1909725] 0 1909725 5517 514 57344 0 0 systemd-udevd
[8560638.743460] [1909749] 0 1909749 5517 614 57344 0 0 systemd-udevd
[8560638.743463] [1909792] 0 1909792 3046 872 61440 0 0 sshd
[8560638.743465] [1909793] 112 1909793 3046 377 61440 0 0 sshd
[8560638.743467] [1909802] 113 1909802 189607 73703 856064 0 0 mysqld
[8560638.743469] oom-kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.slice/mysql.service,task=mysqld,pid=1909802,uid=113
[8560638.743516] Out of memory: Killed process 1909802 (mysqld) total-vm:758428kB, anon-rss:293928kB, file-rss:884kB, shmem-rss:0kB, UID:113 pgtables:836kB oom_score_adj:0
UPD:
Была ошибка
Server sent charset (255) unknown to the client.
Как позже оказалось, она вообще не была связана с кодировкой, но я использовал такую "заплатку", найденную на просторах интернета (изменил my.cnf, снизу дописал эти строчки, а потом убрал):
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
UPD2:
Error Log
2023-10-10T12:57:31.689932Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-10T12:57:33.407960Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 1909758
2023-10-10T12:57:33.475074Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-10T12:57:35.909399Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 1909779
2023-10-10T12:57:35.981559Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-10-10T12:57:38.400025Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34-0ubuntu0.20.04.1) starting as process 1909802
2023-10-10T12:57:38.480893Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
Средний
