You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?
A. Start the MySQL Server in —safe-mode, which only loads the privilege system for changes as data is inaccessible.
B. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
C. Start the MySQL Server with —init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
D. Start the MySQL Server with —skip-grant-tables and execute SQL, which will update the root password.
E. Start the MySQL Server with –initialize-insecure to force a password reset procedure on the command line.
Answer: CD
你无法使用root用户登录到MySQL中，你需要重置root密码来管理数据库。下面哪两个方法能够实现此需求？
A． 使用—safe-mode选项启动MySQL
B． 使用reset-root-password选项启动MySQL
C． 使用—init-file选项启动MySQL，该选项指定到一个SQL文件，文件中包含了用于修改root用户密码的ALTER USER语句
D． 使用—skip-grant-tables选项启动MySQL，然后执行修改root用户密码的SQL语句http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795http://www.cndba.cn/hbhe0316/article/22795

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL