You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade. Examine the message sequence generated during the first start of MySQL 8.0.18: Which step or set of steps will resolve the errors?
A.
Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.
B.
Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
C.
Start mysqld again using the --upgrade=FORCE option.
D.
Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
E.
Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
C, you start mysqld with force upgrade option. New in 8.0
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
marklv
7 months, 4 weeks ago