Блин блинский.
https://timeweb.cloud/tutorials/mysql/kak-sbrosit-parol-root-mysql
Это тоже попробовали?
djamol@fedora:~$ service mysqld stop
Redirecting to /bin/systemctl stop mysqld.service
djamol@fedora:~$ mysqld --skip-grant-tables&
[1] 701360
djamol@fedora:~$ 2024-02-24T11:36:17.280594Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2024-02-24T11:36:17.283969Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36) starting as process 701360
2024-02-24T11:36:17.321187Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2024-02-24T11:36:17.321207Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
2024-02-24T11:36:17.323854Z 0 [ERROR] [MY-010187] [Server] Could not open file '/var/log/mysqld.log' for error logging: Permission denied
2024-02-24T11:36:17.324005Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-02-24T11:36:17.324307Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36) MySQL Community Server - GPL.