"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/clients/drizzle.rst" (6 May 2012, 1030 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:

As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

drizzle Command Line Client

The drizzle command line client is the primary program for ad-hoc connecting to and manipulating a Drizzle database.


Various errors can occur when trying to use the Drizzle command line clients, this is a list of some of these and how to deal with them:

Old Password

drizzle_state_handshake_result_read:old insecure authentication mechanism not supported

This error happens because the Drizzle client is trying to connect to a MySQL server which has the password stored in the Old Password (or pre-MySQL-4.1) format. This is typically seen when connecting to a stock RedHat or CentOS MySQL installation.

To resolve this, look for the old-passwords option in your MySQL configuration and disable it. Then update the password for the user you are trying to connect with using the SET PASSWORD syntax so that it can be re-recorded in the newer password format.