Page 1 of 1

MySQL 5+ Supported?

Posted: Tue Nov 01, 2005 11:40 pm
by Shizzle
Just wondering if NJB works with MySQL 5. If it doesn't then that would explain the error that I get when trying to install NJB.

BTW what are the differences in the table formats anyway?

Re: MySQL 5+ Supported?

Posted: Thu Nov 03, 2005 10:30 pm
by wbartels
Shizzle wrote:Just wondering if NJB works with MySQL 5. If it doesn't then that would explain the error that I get when trying to install NJB.

BTW what are the differences in the table formats anyway?
MySQL 4.1+ uses a new SHA1 password hash witch is not compatible with old PHP-MySQL clients, here you can find a workaround:

http://www.tss2000.nl/vbforum/showthread.php?t=158
http://www.billkatz.com/node/10

Today I have successfully tested netjukebox with PHP 4.41 and MySQL 4.1.15 / 5.0.15
Sorry for the down time :wink:

<update>
Related topic: viewtopic.php?p=181#181
</update>

Posted: Thu Nov 03, 2005 11:54 pm
by Shizzle
so basically I just enter the following into a mysql> command prompt or I edit the my.ini file?

Code: Select all

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('user_password');
thanks,

BTW did you get my two emails that I sent to --- l???