Unable to connect to mysql database

[GoogleCodeExporter]

What is the expected output? What do you see instead?
22:05:17 T:6416 M:1055924224  NOTICE: DEBUG | mythbox.ui | toolkit.py | Line 81 
| showPopup: XBMC.Notification(Settings Error,Connect to MySQL failed: 
Authentication with old (insecure) passwords is not supported: 
http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html,7000)

I have checked and old_passwords=1 is in the my.cnf and I can connect to the 
database from other machines in the network.

Original issue reported on code.google.com by anthony....@gmail.com on 22 Oct 2010 at 4:32

[GoogleCodeExporter]

Any new users you create will have the "new style" password but old users will 
remain unchanged. You've got a couple of choices:

1. create a new mysql user with the same access rights as the existing mythtv 
user
2. reset/change the password for the existing mythtv user

Original comment by semir.pa...@gmail.com on 25 Oct 2010 at 2:55

[GoogleCodeExporter]

Thanks, 

I ended up creating another user with access to the mythconverg database and 
all appears to be working correctly.

Thank You

Original comment by anthony....@gmail.com on 25 Oct 2010 at 6:39

[GoogleCodeExporter]

Original comment by semir.pa...@gmail.com on 26 Nov 2010 at 3:16

• Changed state: Notvalid

[GoogleCodeExporter]

Original comment by semir.pa...@gmail.com on 26 Nov 2010 at 3:17

• Changed state: Invalid