stored procedures & external languages ! and faster they reckon though I can't really see that but anyway
Is Mysql all grown up now?
I noticed that I was having problems connecting with mysql using php. When I read the php page on mysql functions someone had posted a note about password authentication problems with mysql5
Seems that you need to set a password using old_password('password') if you are going to connect to a mysql5 db using php.
I used the following for my db and it then connected fine with php.
update user set password=OLD_PASSWORD('factorytest') where user = 'factory';
I'm not sure if this has been posted elsewhere but thought I'd point it out in case others ran into the same problem.
I won't double post this elsewhere, if one of the modirators thinks it should be posted elsewhere too go ahead.
If you need the features offered ( or will be offered) in MySql 5.0, then you should consider Firebird 1.5 database which already have those features and is much more mature and no license cost.
I'm in the process of converting our mysql db to firebird.
- slamdunkinpoolJAMyahooDOTcom ( remove 'JAM' )