mysql8.0英文OCP考试第131-140题

Q131.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:

。。。[System]。。。/usx/sbin/mysqld (mysqld 8.0.18-commercial) starting as process 2754

。。。[System]。。。Starting upgrade of data directory. .

。。。[ERROR]。。。。Table upgrade required. Please do ‘’REPAIR TABLE ‘columns_ priv'" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ‘event’" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ’proc'" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ’proxies_ priv’" or dump/reload to fix it!

。。。[ERROR]。。。Table upgrade required. Please do "REPAIR TABLE ‘tables_ priv’" or dump/reload to fix it!

。。。[ERROR]。。。Failed to open mysql.event Table.

。。。[ERROR]。。。Failed to open mysql.proc Table.

。。。(ERROR]。。。Failed to Populate DD tables.

。。。[ERROR]。。。Aborting

。。。[System] 。。。 /usr/sbin/mysqld: shutdown complete (mysqld 8.0.18-commercial) MySQL Enterprise Server - Commercial.

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.