CocoaMySQL cannot connect to MySQL > 4.1 because of the new password enryption. If you want to connect to a server running MySQL > 4.1, you have to use one of the following solutions: [...]
SQLTunes
send iTunes library data or playlists to MySQL
Version: 0.019
MySql Version
Feedback Type: Troubleshooting Report
Contributed by: zetetes Sunday, August 21 2005 @ 01:20 PM PDT
Product Platform: MacOSX
Used Product For: Have Not Tried
Recommend Product: YES
it seems to me your version 0.012 is not working with mysql-client v5.0.1, since i can't connect to my running mysql-server (permission denied).
i had a similar problem with CocoaMySQL, fixed in CocoaMysql-SBG.
System Info:MySQL-Server: 4.1.10-log via socket
MySQL Client Version 5.0.1
MySql Version - vonkessel
Using MySQL 4.1 and GreaterAs of MySQL version 4.1, MySQL uses a new password hashing schema. Due to a bug in RealBasic you must use the old MySQL password schema to connect to your databases. You must adjust your MySQL user account to use the old password schema. To do so, issue the following sql…
mysql> SET PASSWORD FOR -> ’some_user’@’some_host’ = OLD_PASSWORD(’newpwd’);
More information on this issue can be found here… http://dev.mysql.com/doc/mysql/en/old-client.html This information is found in both the AboutSQLTunes.html and the FAQ found on our website.
Reply to This
Sunday, August 21 2005 @ 05:21 PM PDT