Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

closed as off-topic by MadHatter, kce, cole, Falcon Momot, Magellan Dec 4 '13 at 16:22

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "Questions must be relevant to professional system administration. Server Fault is dedicated to professional system and network administrators. End user and enthusiast questions are off-topic (contact your system administrator or hire a professional to help you out). Please see the Help Center for more information." – MadHatter, cole, Magellan
  • "Questions must demonstrate a minimal understanding of the problem being solved. Try including attempted solutions, why they didn't work, and the expected results. See How can I ask better questions on Server Fault? for further guidance." – kce, Falcon Momot
If this question can be reworded to fit the rules in the help center, please edit the question.

3  
I think it unlikely you'll get much help here. Professional environments almost never use these sorts of "stacks" to deploy web applications; they are generally designed for developers and enthusiasts, people at the very end of the long tail, and people who don't actually know how to administer a web site. –  Michael Hampton Dec 2 '13 at 18:46
    
I remember installing it one by one. Not through LAMP or Webuzo. –  user124245343 Dec 2 '13 at 18:59
    
But through terminal, the MySQL status is running <- How have you determined this? You need to describe things with some level of detail that would be useful to a person who knows nothing about your environment –  voretaq7 Dec 3 '13 at 19:00

6 Answers 6

Many ways to do it - in your terminal:

sudo service mysql status

or

ps aux | grep mysql

What you're facing is probably authentication failure or database misspell.

Did you try logging in with same creds via Terminal?

mysql -u <username> -p <database-name>

Hope it helps :)

share|improve this answer
2  
Also check to what IP address the daemon is bound. Maybe you're using the wrong one and that is the reason for the failure? –  Michael Kjörling Dec 3 '13 at 10:11

You can check the MySQL service status as follows :

`Root > service mysqld status

or

Root > ps aux | grep mysql

or

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

share|improve this answer

Default MySQL server port is 3306, if it's running then you'll have to check for the right port being used:

# netstat -vulntp |grep -i mysql

If no results returned then you'll have to check your MySQL log.

share|improve this answer

ps uxa | grep mysqld

If there is output, your mysqld is active. (Although it can be yet unreachable, but that will be your next question soon)

share|improve this answer

"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.

share|improve this answer
  1. lsof -i :3306 a

and

  1. mysqladmin processlist
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.