MySQL 8 OCP(1Z0-908)认证考试题库原题(第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:

MySQL 8 OCP(1Z0-908)认证考试题库原题(第11题)

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.

MySQL 8 OCP(1Z0-908)认证考试题库原题(第11题)

 

MySQL 8 OCP(1Z0-908)认证考试题库原题(第11题)

上一篇:查看Mysql表空间大小 优化空间


下一篇:数据库脱敏查询