Problems installing SugarCRM 5.0.2a

[TestSugar1]

Hello

I installed SugarCRM 5.0.2a on my local computer (to make tests) and I had some problems. I understood that I could install the software only if I was connected with the 'administrator' login on the computer, and not with an other login that would have administrator rights.
Enventually, I managed to install Sugar on my computer.

The problem is that now I must install the production database on a VM (Virtual Machine), and I have the same installation problems, however I connect with the 'administrator" login or with another with admin rights.

The install seems to happen well, but at the end, when I launch Sugar, it's the http://127.0.0.1/sugarcrm/install.php page that is launched, and I am supposed to do the install again... and it doesn't work.

I get the following message:

Création de fichier de configuration Sugar (config.php)

Création de tables de l'application Sugar, tables d'audit, et relations des metadonnées...
Création de la base de données sugarcrm ok 127.0.0.1...fait
Unable to select database: Access denied for user ''@'localhost' to database 'sugarcrm'

Do you know how I can solve my problem?
Thanks for your help

NB : I downloaded the sugarcrm-CE-5.2.0a-windows-installer.exe file using « FastStack Windows Installer for 5.2.0a with MySQL » on the SugarCRM website.

[TestSugar1]

Hello,

Any idea to help me?

I'm completely stuck...

[crmsiva]

Possible things are,

1. you do not have access to the DB.

2. DB is not in your local machine

[TestSugar1]

Possible things are,

1. you do not have access to the DB.

2. DB is not in your local machine

OK I understand that this is what the message means... but I'm using the complete package to install SugarCRM, so I'm installing MySQL at the same time as SugarCRM.
Then I don't understand how problems 1 or 2 could happen...

[crmsiva]

ok. Are you sure your MySql is running?

Could you post the following details from your config.php?

'dbconfig' =>
array (
'db_host_name' => '',
'db_host_instance' => '',
'db_user_name' => '',
'db_password' => '',
'db_name' => '',
'db_type' => 'mysql',
),

[TestSugar1]

ok. Are you sure your MySql is running?

Mmmm... How can I check that?

Could you post the following details from your config.php?

Are you talking about the file that is created in C:\Program Files\sugarcrm-5.2.0a\htdocs\sugarcrm?

If I try the install by double-clicking on the .exe file, this config.php file is empty.

Then, if I try again the install via the http://127.0.0.1/sugarcrm/install.php page, I get:

'dbconfig' =>
array (
'db_host_name' => '127.0.0.1',
'db_host_instance' => 'SQLEXPRESS',
'db_user_name' => 'administrator',
'db_password' => 'Logica44',
'db_name' => 'sugarcrmdb',
'db_type' => 'mysql',
),

Is it OK?

[crmsiva]

Try like this

'db_host_name' => 'localhost',
'db_user_name' => 'root',
'db_password' => '',

Also make sure that you db is sugarcrmdb or sugarcrm

[TestSugar1]

Try like this

'db_host_name' => 'localhost',
'db_user_name' => 'root',
'db_password' => '',

Also make sure that you db is sugarcrmdb or sugarcrm

Sorry, I tried first the install with a DB called 'sugarcrm' and then 'sugarcrmdb', because I wondered if the problem could come from there... but apparently no.

I tried the modifications you gave me, and I stopped and started again SugarCRM Service.
Now, when I go to "Start here", I get an internet page with:

Could not connect to server localhost as root.Access denied for user 'root'@'localhost' (using password: NO)

[crmsiva]

Did you left the db_password empty? If not leave it as empty and check

[TestSugar1]

Did you left the db_password empty? If not leave it as empty and check

Yes, I had left ot empty, and that's the error message I got.

Now if I modify again the config.php file putting a password again, stop and start the Service again, here is the error message:
Unable to select database: Unknown database 'sugarcrmdb'

EDIT:

If I change the config.php file again to put 'db_name' => 'sugarcrm', (instead of 'db_name' => 'sugarcrmdb',), I get almost the same error message:
Unable to select database: Unknown database 'sugarcrm'