Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

I followed the macos installation of MariDB on their website and I always get this error when I try to run mysql_upgrade

I also can't secure the installation due to the same error

Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
FATAL ERROR: Upgrade failed
I tried following tutorials but they don't work.
What should I do?
Sorry, I forgot I posted a question here.
It's all good now! I was able to make it work. All I did was use mariadb -u root -p instead, and the password was root.
The tutorial I used was the one from Mariadb's official website.
As for this solution, I forgot where I got it from but, kudos to you who helped me!
mysql_upgrade -p
it will prompt for root password. You can even run it with a different user using the -u option.
Hope this helps.
FYI: https://mariadb.com/kb/en/mysql_upgrade/
                If you are still facing the issue after performing mysql_upgrade, then try stopping the MySQL service and then start it again (Do not perform restart).
– Kapil Khandelwal
                Oct 8, 2022 at 11:19
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.