Cant open sugar with db issues

[tshepoth]

Hi all

Have sugar community 6.3.1 on a hosted shared server. Sugar was working very well until I change the password of the database user which is linked to my sugar install for another database I created. When i tried to open my sugar I got the following error:

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'crmhotrp_pulego'@'localhost' (using password: YES) in /home/crmhotrp/public_html/angelinternational/include/database/MysqliManager.php on line 297
Could not connect to the database. Please refer to sugarcrm.log for details.

I know I have to change user access using phpMyadmin but dont know how to do that. Tried to read a few articles and im not winning. Any easy way to do this?

[kuske]

Did you changin the the password of the mysql user in the config.php file?

[tshepoth]

Just changed that and got the following issues:

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/crmhotrp/public_html/angelinternational/config.php:1) in /home/crmhotrp/public_html/angelinternational/include/MVC/SugarApplication.php on line 580

Warning: Cannot modify header information - headers already sent by (output started at /home/crmhotrp/public_html/angelinternational/config.php:1) in /home/crmhotrp/public_html/angelinternational/include/utils.php on line 2387

Warning: Cannot modify header information - headers already sent by (output started at /home/crmhotrp/public_html/angelinternational/config.php:1) in /home/crmhotrp/public_html/angelinternational/include/MVC/SugarApplication.php on line 122

Any ideas how to solve this?

[kuske]

Perhaps you did a typo in the config.php, check the Apostrophes, the must be ' Apostrophes , no ` or ´ .

[tshepoth]

Thanks for a quick response. The is no typo whatsoever. Tried to create a new user with all privileges to the database which took me back to the first problem!

[kuske]

There must be a big in the config.php.

How does the end look like?

is there an empty line after the "?>"

remove it

[tshepoth]

There must be a big in the config.php.

How does the end look like?

is there an empty line after the "?>"

remove it

This is how the file ends:

'upload_dir' => 'cache/upload/',
'upload_maxsize' => 3000000,
'use_common_ml_dir' => false,
'use_real_names' => true,
'vcal_time' => '2',
'verify_client_ip' => true,
);

I cannot find "?>"

[tshepoth]

Thanks Kuske for trying to help. I got the solution from Rafael's post on http://www.sugarcrm.com/forums/f22/h...69/#post269927