Unknown database 'mysql'
Hey guys i have installed mariadb on arch, started "sudo mysql_secure_installation" but then there was a password required i tried to press enter for empty but it didn't work, after that i tried to run mariadb in safe mode using "sudo mysqld_safe --skip-grant-tables --skip-networking &" but when i tried to use mysql database to reset password there was no database called mysql created by default i got this error "Unknown database 'mysql'" after running "/usr/bin/mysql_install_db" it didn't work as well any idea? even reinstalling didn't solve the issue
Answer Answered by Daniel Black in this comment.
I assume you are following https://wiki.archlinux.org/title/MariaDB.
I can't tell why mysql is "Unknown database".
There's some really horrible recommendations on the wiki in archlinux.
If its a new install, I recommend removing your datadir contents and reinstall with
mariadb-install-db --user mysql --skip-test-db, then start MariaDB.
Don't use mysql_secure_installation (skip-test-db covers most of it), and its a less than maintained script.