Oracle
1Z0-883 · Question #14
You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice: ERROR 2059 (HY000): Authentication plugin `mysql_clear_password' connot be loaded…
The correct answer is C. The mysql client with the ?enable-cleartext-plugin option. See the full explanation below for the reasoning.
Question
You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin `mysql_clear_password' connot be loaded: plugin not enabled What would you run to fix the issue?
Options
- AThe mysql client with the ?ignore-password-hashing option
- BThe mysql_secure_installation script to update server security settings
- CThe mysql client with the ?enable-cleartext-plugin option
- DThe mysql_upgrade script
- EThe install plugin command for the mysql_cleartext_password plugin
How the community answered
(28 responses)- A4% (1)
- B11% (3)
- C82% (23)
- E4% (1)
Community Discussion
No community discussion yet for this question.