|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi all, thank you in advance for your help!
I am using and Asterisk based server (TrixBox 2.2) that hasw Mysql 4.1.2 and PHP 2.8.2.2 ans SugarCRM installed. Here is the issue and there is some cross over with other posts here: I get the following error when trying to connect to SugarCRM: Warning: mysql_connect(): Access denied for user 'sugarcrm'@'localhost' (using password: YES) in /var/www/html/crm/include/database/MysqlManager.php on line 468 Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /var/www/html/crm/include/database/MysqlManager.php on line 493 Could not connect to server localhost as sugarcrm.Access denied for user 'sugarcrm'@'localhost' (using password: YES) That said, I am able to log on and have all the passwords for mysql, root, sugarcrm, etc. I have granted access to sugarcrm. I have tried removing the password for sugarcrm (it still shows the same message above 'password - YES'). I am on my desk now. The only other issue that I have tried, unseccessfully to work with is the "old password" encription issue related to 4.1 + and older programs. I have tried this fix, with now success. Any help is greatly appreciated!!! |
|
#2
|
|||
|
|||
|
Hi ShawnESC (fellow SugarCRM User
) pls try the following:1.) If you only have recently made the Password Changes, you might want to restart the MySQL Server or flush the priviliges so MySQL will be aware of the changed user settings: Flush User Priviliges: mysql -u {ROOT_USER} -p{PASSWORD} flush-privileges; restart MySQL: mysqladmin -shutdown -u {ROOT_USER} -p{PASSWORD} mysqld_safe & 2.) Next thing to try is to check if the correct passwords are indeed stored in the config.php of SugarCRM. Check that the host/username/password are correct. I would recommend that you try flushing priviliges first, or better yet set new password for sugarcrm, the do the flush and try again. And make sure that the new password is reflected on the config.php |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Need help PLEASE !- localhost - access denied |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|