We have SugarCRM in Amazon EC2. which was working fine until for last few day we facing issue "could not connect to the database. Please refer to sugarcrm.log for detail".
Opened the "Sugarcrm.log" Found the below message
"Could not connect to DB server localhost as root. port 3306: No such file or directory"
checked the "config.php" file, it is fine.
we have tried start, stop and restart the MYSQL it does not start.
even couldn't access the MYSQL database in phpmyadmin using "root" username and password.
Tried the change "root" password. i could not change it.
$ sudo tail -n 100 /opt/bitnami/mysql/data/mysqld.log and found an error,
tried all the suggestion available in bitnami community, but could not start the MYSQL database