Perhaps you started mysqld with --old-passwords before but not after the reinstall? Leaving that out would prevent connections from python unless it was compiled with the mysql lib from 4.1.0.
See <http://www.mysql.com/doc/en/Password_hashing.html> for more on the various password hash sizes and their interactions with different version clients.
Michael
Michael Satterwhite wrote:
I received a suggestion that the problem might be in the privilege tables. Note that this server has never been at a level less than 4.1. The password field in user is 45 char long, and passwords already begin with a "*".
The suggestion was a good one based on the symptom, but it doesn't apply here.
On Monday 19 January 2004 07:25, Michael Satterwhite wrote:
I'm running the SuSE 8.2 distro with MySQL 4.1.0-0 and python-mysql-0.9.1-430.
On Saturday, I had to do a reinstall of everything (long story). The software listed above is the same as it was before the reinstall. The only difference is that this time I installed 4.1 directly, before I had done an upgrade from 4.0 to 4.1.
I try to connect to MySQL as follows:
import MySQLdb db = MySQLdb.connect(user="michael", passwd="*****", db="backups")
When I do this, I get the following exception:
_mysql_exceptions.OperationalError: (1249, 'Client does not support authentication protocol requested by server. Consider upgrading MySQL client')
Tables are INNODB, but we're not to that point yet. The MySQL client is the one with the 4.1 beta release - and worked before the reinstall.
Can anyone offer me any help??
tia ---Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]