I have installed Webuzo on my unmanaged VPS. I am not able to install any applications, since it is giving me errors such "Unable to connect to MySQL server". But through terminal, the MySQL status is running.
Can anybody help how to troubleshoot?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
You can check the MySQL service status as follows :
`Root > service mysqld status
Root > ps aux | grep mysql
// Is MySQL listening to the required port
Root > lsof -i :3306`
You can check the status of the MySQL service from the Webuzo Enduser Panel >> Services Menu. Guide : http://webuzo.com/wiki/Restart_services
As for your error "Unable to connect to MySQL server", are you able to create databases from the Webuzo Enduser Panel ? Guide : http://webuzo.com/wiki/How_to_Create_and_Manage_MySQL_Databases
Did you change the MySQL root users' password ? Password for the MySQL root user is in the file /var/webuzo/my.conf
If the MySQL service is running, try accessing the MySQL server from the terminal.
Hope it helps \m/
"process is running" is not same as "service is available" for everywhere.
check your detail logs on both client and server side to find error detail, and check service connection status by manual connection:
$ mysql ...
from DB server locally, and from client.
I don't know about Webuzo. it's just general answer.