phpMyadmin - Can not log in using correct user/pass!

[skuliaxe]

I installed SugarCRM 5.5.1 CE with a Stack installer. I chose to install phpMyadmin aswell.

Now, when opening "http://localhost:80/phpMyadmin" the login screen opens. I type in the username and password but it pops back up like the username was wrong.

So then I open sugarcrm/config.php and use the following to login:

array (
'db_host_name' => 'localhost',
'db_host_instance' => 'SQLEXPRESS',
'db_user_name' => 'root',
'db_password' => '*******',
'db_name' => 'sugarcrm',
'db_type' => 'mysql',
),

That has the same results. I cant log into the database via phpMyadmin. I´ve also checked the config.inc.php under the phpMyadmin folder. I´m always using the same user and password but I can´t seem to log in.

Any help would be great.

[salesagility]

The details in config.php relate to your database authentication. Are you trying to login as "root" into sugarcrm ... if so, try logging in as "admin" with your usual password

[skuliaxe]

Thanks for the reply,
I open http://localhost:80/phpMyadmin and use "root" and "*******" where ***** is the database connection password for the SugarCRM install.
I have also tried my SugarCRm "admin" and "*******" where ******* is actually the same as the database password. I use a 20+ letter and secure password.

Could there be a conflict if the mysql root password is the same as sugarcrm admin password?

Kind regards
Skuli

[Angel]

This sounds like it might be a problem with the session.save_path setting in your PHP.INI.

Give it a look to make sure it is set to a directory that exists and to which the web user has full access.

I've seen similar situations where it might let you login, but then when you click on something, you immediately get sent to login again.

If you need to adjust your PHP.INI, make sure that you restart your web service to apply the setting.

[skuliaxe]

This sounds like it might be a problem with the session.save_path setting in your PHP.INI.

Give it a look to make sure it is set to a directory that exists and to which the web user has full access.

In my php.ini the session save path is:

session.save_path = "C:\Program Files\sugarcrm/php/tmp"

And in that tmp folder there are files named "sess_0eqc8ca5sfcpcf752........."

So that does not seem to be the problem. I have tried Explorer 6 and Chrome 4, cleared all browsing history and temporary files, sessions. I´m looking on Google but cant find a solution for my instance. Hoping that other SugarCRM users that have used the Stack installer have a better idea what this might be.

[kuske]

You can set the application password of user admin in phpMAdmin to ***newpassword*** with the sql command

update users
set user_hash = md5('***newpassword***')
where user_name = 'admin';

[skuliaxe]

Well I´ve manage to log into phpMyAdmin. But the SugarCrm database is not there. Just the information_schema and an empty test database.

Any ideas how to connect the SugarCRM database?

[ptemplin7]

Sounds like the database was not created correctly the first time.

You can change the line install = True; tio install=false; int he config.php and runt he install script again.

After that check to see if sugarcrm (default) DB was created if not. You have some other issue.

Good Luck, Paris

[skuliaxe]

Thank for the replies.

I am currently using SugarCRM with data. So the database and tables are there. phpMyAdmin is just not connection correctly. I didn´t change any default ports so I would think that the port phpMyAdmin is using is correct.

[skuliaxe]

Thanks for all the help.
For some reasong the sugarcrm database is now showing up. I didn´t change a thing. Strange.