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.

©著作权归作者所有:来自51CTO博客作者cto_5359的原创作品,如需转载,请注明出处,否则将追究法律责任

更多相关文章

  1. MySQL 8 OCP(1Z0-908)认证考试题库原题(第12题)
  2. OCP 071中文考试题库-第1题
  3. OCP 071中文考试题库-第2题

随机推荐

  1. Android(安卓)实现沉浸式体验
  2. 初识SeekBar
  3. 手机拨号器
  4. Android介绍如何生成keystore 文件并使用
  5. Android WIDGETS 下的Power control修改
  6. Android——按钮类控件
  7. 【Android Demo】让Android支持自定义的t
  8. android 程序启动界面的短暂黑屏
  9. cocos creator android studio多渠道打包
  10. Android开发之获取常用android设备参数信