topic alfresco 1.4 and MySQL 5.0 in Alfresco Archive

alfresco 1.4 and MySQL 5.0

mabayona — Tue, 26 Sep 2006 07:29:55 GMT

Hi,has anybody got alfresco running with MySQL 5.0.X?I have installed alfresco 1.4 and MySQL 4.X several times with no problem. But when i try with MySQL5.0.x i get problems . I get no further and even the database is not created. It seems that alfresco does not get connected with MySQL. The followi

Re: alfresco 1.4 and MySQL 5.0

kevinr — Tue, 26 Sep 2006 08:39:33 GMT

We and several of our customers use MySQL 5 with no problems. Can you test that you can connect to the DB from that machine? Also can you check the username/password combination to the database, and that you have given access rights to that user to the DB. I'm just guessing as this is our default setup and there is not a known problem.

Thanks,

Kevin

Re: alfresco 1.4 and MySQL 5.0

mabayona — Tue, 26 Sep 2006 11:54:13 GMT

Yes, that was it. It was a silly permision thing (that changes from MySQL 4 to MySQL 5 by the way). All that was missing was the permission on user alfresco on schema alfresco (this permission got lost when deleting the database and recreating it).

All I did was to create the DB alfresco and assigning all permissions again from user alfresco in database alfresco. It works now.

Thanks.