MySQL connection error 1043 bad handshake (svn 1510 64-bit ubuntu)

[GoogleCodeExporter]

What steps will reproduce the problem?
1. 'standard' installation - latest xbmc (not svn), mythbox svn 1510,
mythtv 0.21 (mythdora) on fedora server
2. configure mythtv & mysql settings
3. test settings

Error message
Connect to MySql failed: 1043 (08S01):Bad Handshake

Used mythbox svn1260 successfully under Windos 7 64-bit. svn1260 on ubuntu
 had (documented) problems with _mysql.so so upgraded to svn1510

Attached is mytbox.log  & xbmc.log

Original issue reported on code.google.com by pinthe...@gmail.com on 18 Oct 2009 at 9:05

Attachments:

• mythbox.log
• xbmc.log

[GoogleCodeExporter]

I'm thinking your mysql password is set using mysql 4.0 compatibility mode 
instead of
the new password scheme introduced with mysql 4.1. This is pretty easy to 
change if
you have phpmyadmin installed (a quick google seach should help you along) . 
Reset
your password to 4.1+ mode and let me know if that fixes your problem.

Original comment by semir.pa...@gmail.com on 18 Oct 2009 at 3:21

• Changed state: Accepted

[GoogleCodeExporter]

Will try this evening - I'll setup a new account for xbmc. Does mythbox need 
update
rights or only read?

Original comment by pinthe...@gmail.com on 19 Oct 2009 at 7:55

[GoogleCodeExporter]

Created a new account with 4.1 password and it works now. I only gave the 
account
select rights, but I may need to increse as xbmc crashes when I try to select a
recording. Otherwise I'll open a new issue

Original comment by pinthe...@gmail.com on 19 Oct 2009 at 5:08

[GoogleCodeExporter]

Your new user needs all the same privileges as the mythtv user.  
Solution added to FAQ as Q14 in svn 1541

Original comment by semir.pa...@gmail.com on 19 Oct 2009 at 6:00

• Changed state: Done
• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

Thanks analogue! That fixed my issue.

UPDATE mysql.user SET Password = PASSWORD('password') WHERE Host = '%' AND User 
=
'mythtv';

Original comment by wes...@gmail.com on 28 Oct 2009 at 1:55