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