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