topic Re: Mysql .... in Alfresco Archive

Mysql ....

zig1 — Wed, 14 Dec 2005 13:20:12 GMT

Hello,I am installing Alfresco.My folder mysql isn't on c:\mysql but in c:\Program Files\EasyPhp1-8\mysqlThe db_setup.bat do not works … of course.How Can I run it ??Should I create the new database by myself under PhpMyAdmin ??Thanks for your help

Re: Mysql ....

davidc — Wed, 14 Dec 2005 14:07:48 GMT

I don't believe that mysql has to live in a specific directory.

What error are you getting from db_setup.bat?

Make sure you can connect to your mysql instance as per the readme…

Test MySQL is installed and running by opening a command prompt and entering:
  'mysql -u root -p'‍‍

Re: Mysql ....

zig1 — Wed, 14 Dec 2005 15:04:59 GMT

I do not receive any message.
The window open and close, and I do not see a new db in PhpMyAdmin.
I do not know how and from where to type this command.
I am very bad at that …

Re: Mysql ....

gavinc — Thu, 15 Dec 2005 08:12:51 GMT

There is a sql script file "db_setup.sql" which contains the commands you need to run.

You can run this file directly but you must have c:\Program Files\EasyPhp1-8\mysql in your system's PATH environment variable.

Alternatively you can create the database via the MySQL command line or phpMyAdmin, the commands you need to run are:

create database alfresco;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;‍‍

Hope that helps.

Re: Mysql ....

zig1 — Thu, 15 Dec 2005 10:04:05 GMT

It works

I have a java error … But it is running !!!!

Thank you very much