MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 16th, 2007, 09:58 AM
ShawnESC ShawnESC is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2007
Posts: 1 ShawnESC User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 18 m 51 sec
Reputation Power: 0
Exclamation Need help PLEASE !- localhost - access denied

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!!!

Reply With Quote
  #2  
Old October 2nd, 2007, 06:44 PM
Arpee Ong Arpee Ong is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2007
Posts: 7 Arpee Ong User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 25 sec
Reputation Power: 0
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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > Need help PLEASE !- localhost - access denied


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
Stay green...Green IT