MySQL 5+ Supported?

General discussion about netjukebox
Post Reply
Shizzle
User
Posts: 65
Joined: Sat May 28, 2005 9:00 am
Location: Gresham, OR USA
Contact:

MySQL 5+ Supported?

Post 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?
User avatar
wbartels
netjukebox developer
Posts: 881
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: MySQL 5+ Supported?

Post 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>
Shizzle
User
Posts: 65
Joined: Sat May 28, 2005 9:00 am
Location: Gresham, OR USA
Contact:

Post 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???
Post Reply