Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第11题
Choose the best answer.
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) Start mysqld again using the --upgrade=FORCE option.
B) Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
C) Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
D) 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.
E) Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.