Mysql 8.0 OCP认证考试原题整理（CUUG内部题库）-第11题

时间：2020-12-11 来源：

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/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.