|
2425.2.2
by Daniel Nichter
A lot of doc changes: rewrite and expand Configuration and Administration, re-order top-level sections, enhance Contributing, add Release Notes, add Help and Support, fix title casing, label all plugins, other misc. enhancements. |
1 |
.. _drizzle_command_line_client: |
2 |
||
3 |
drizzle Command Line Client
|
|
4 |
===========================
|
|
5 |
||
|
1794.2.9
by Monty Taylor
Made some TOC structure changes. Added stubs for a couple of command line |
6 |
The :program:`drizzle` command line client is the primary program for ad-hoc |
|
2222.2.1
by Mark Atwood
documentation work |
7 |
connecting to and manipulating a Drizzle database. |
|
1794.2.9
by Monty Taylor
Made some TOC structure changes. Added stubs for a couple of command line |
8 |
|
|
2425.2.2
by Daniel Nichter
A lot of doc changes: rewrite and expand Configuration and Administration, re-order top-level sections, enhance Contributing, add Release Notes, add Help and Support, fix title casing, label all plugins, other misc. enhancements. |
9 |
Errors
|
10 |
------
|
|
11 |
||
12 |
Various errors can occur when trying to use the Drizzle command line clients, |
|
13 |
this is a list of some of these and how to deal with them: |
|
14 |
||
15 |
.. _old-passwords-label: |
|
16 |
||
17 |
Old Password
|
|
18 |
^^^^^^^^^^^^
|
|
19 |
||
20 |
``drizzle_state_handshake_result_read:old insecure authentication mechanism not supported``
|
|
21 |
||
22 |
This error happens because the Drizzle client is trying to connect to a MySQL |
|
23 |
server which has the password stored in the Old Password (or pre-MySQL-4.1) |
|
24 |
format. This is typically seen when connecting to a stock RedHat or CentOS |
|
25 |
MySQL installation. |
|
26 |
||
27 |
To resolve this, look for the old-passwords option in your MySQL configuration |
|
28 |
and disable it. Then update the password for the user you are trying to connect |
|
29 |
with using the ``SET PASSWORD`` syntax so that it can be re-recorded in the
|
|
30 |
newer password format. |
|
31 |