Project

General

Profile

Feature #615

MySQL is using old password standard

Added by Oldi about 11 years ago. Updated about 11 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
08/22/2010
Due date:
% Done:

0%


Description

Fedora default setting for MySQL in my.cnf is old_password=1

This should be updated to old_password=0

The old password style gives problems with third party apps accessing the MySQL db's on the AMAHI server. I tripped on this when trying to connect XMBC (www.xbmc.org) against HDA & MythTV

History

#1 Updated by maniro about 11 years ago

For reference:

The old_passwords option only changes how mysqld generates new
passwords. If old_passwords=0 when you create a new user mysql will
generate a long password that will only accept clients using the newer
protocol (and client lib). When old_passwords=1 mysql will generate
the older shorter passwords that will accept clients using the old
protocol (and client lib)

It's possible to have some clients use the old protocol and some using
the new protocol by changing their passwords accordingly. This is what
the old_password function is for in both mysql and phpmyadmin.

(from http://lists.mysql.com/mysql/203620)

Also available in: Atom