AnsweredAssumed Answered

Problems installin MySQL with Alfresco

Question asked by marãƒâ­a on Aug 24, 2007
Latest reply on Aug 30, 2007 by mikeh
Hi! This is the first time I’m using Alfresco. I have a lot of questions and my English is not very good. I’ve been working with an Alfresco version that works with HSQL. Now I’m trying to change HSQL with MySQL. What I have done is the next:

I have downloaded MySQL Server 5.0.
I have installed it with the typical installation (next, next…).
I’ve installed it as a Windows service and I’ve included MySQL in path.
Then I’ve run mysql -u root –p and it’s worked with no errors.

The problem is the next:

“Navigate to the 'C:\alfresco' folder and run 'db_setup.bat'.  This creates a MySQL database named 'alfresco' with a user account and password of 'alfresco'.  If db_setup fails, this may be because the MySQL service is not running or that the mysql command cannot be found.  Either correct this or setup the Alfresco database and user manually by loading the 'db_setup.sql' file into MySQL, for example, 'mysql -u root -p <db_setup.sql'â€