''mysql_upgrade' Access denied for user 'root'@'localhost' on M1 Mac
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?
EDIT
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!
Solution 1:[1]
You haven't posted which tutorials you have followed. Have you tried
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Tms91 |