Updating mysql privilege database failed
For more nuance, you can read the documentation here: https://dev.mysql.com/doc/refman/5.7/en/This solved it for me.When I looked at the status of the mysql daemon, I saw this warning: "[Warning] 'user' entry '[email protected]' has both a password and an authentication plugin specified. New password: Re-enter new password: The 'validate_password' plugin is installed on the server.Inno DB: Log scan progressed past the checkpoint lsn 588190222435 130730 Inno DB: Database was not shut down normally! Inno DB: Reading tablespace information from the files...Inno DB: Restoring possible half-written data pages from the doublewrite Inno DB: buffer...I couldn't find a direct cause and solution to the problem I was having, so I resorted to re-installing My SQL to see if that would work. That was a lame way to fix it, but it was the only option I had left.A lot of the other answers on this question are problems I had to work through to get mysql_upgrade to run initially, but for whatever reason - it failed as it was trying to run some automated queries, and I couldn't find the documentation on which queries it was running so I could fix them.
You need first to update the root password with the new format and then you can upgrade your mysql. I solved it by including the -S /path/to/In my particular case the output of mysql_upgrade was: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed That's pretty useless. Plugging around I settled on the following command and it worked like a charm: mysql_upgrade -S /var/lib/mysql/-u USERNAME -p Hope it helps. Then I was able to start mysql daemon and use 'mysql' or whatever you want connected with mysql package.I had this problem on slackware arm , but suppose it doesn't matter in this case. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).Would you like to answer one of these unanswered questions instead?jh6ql 2016-01-22T.496812Z 1 [Note] A temporary password is generated for [email protected]: (B*=T! (Press y|Y for Yes, any other key for No) : Y By default, a My SQL installation has an anonymous user, allowing anyone to log into My SQL without having to have a user account created for them.
u WJ7ws 2016-01-22T.088610Z 1 [Note] A temporary password is generated for [email protected]: %t JXK7syt MJV 2016-01-22T.384205Z 1 [Note] A temporary password is generated for [email protected]: lsl QDvgwr3/S 2016-01-22T.772275Z 1 [Note] A temporary password is generated for [email protected]: S4u J, Rce_0t [[email protected] ~]# mysql_secure_installation ... Error: Your password does not satisfy the current policy requirements That means your password needs to have a character such as ! This is intended only for testing, and to make the installation go a bit smoother.130730 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 130730 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130730 [Note] Plugin 'FEDERATED' is disabled.