HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Debian 5.0 -ISPConfig 3 install - Unable to connect to mysql server (http://www.howtoforge.com/forums/showthread.php?t=31425)

anushanw 17th February 2009 16:54

Debian 5.0 -ISPConfig 3 install - Unable to connect to mysql server
 
I have followed all the steps given in the manual and so far it was going well till i started installing ISPConfig 3
I started installing ISPConfig 3 with the SVN, selected the language and used the default (which are appropriate) values for the questions
when it try to connect to MySQL server or the database it asked me the questions to enter hostnamme, username, password, database to crease, charset.

Then it gave me an error saying:
"Unable to connect to mysql server Can't connect to local MySQL server through socket 'var/run/mysqld/mysqld.sock' (2)

Any idea what i should do?

till 17th February 2009 17:18

This means that your mysql server is not correctly installed or running. Please redoo the mysql installation steps from the ispconfig 3 manual and make sure that you really started the mysql server.

anushanw 17th February 2009 17:27

i did install the mysql server and other things in step 1. howeever i re-did it right now and it gave me a sessage saying everything is uptodate.
when i type the command "/etc/init.d/mysql restart" it displayed the following

Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

and for "/etc/init.d/mysql status" it gives
Server Version 5.0.51a-24
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
uptime: 2 mins 2 sec

Threads: 1 Questions: 78 slow queries: 0 Opens: 23 Flush Tables: 1 Open tables: 17 Queries per second avg: 0.639

Any thing that you can think of???

anushanw 17th February 2009 17:34

Well it worked for one reason or the other when i asked for the status and re ran the installation process with the root password.

Thank you for your help.

RomaSvcs 4th May 2009 22:59

Can't connect to mySQL to /var/lib/mySQL/mySQL.sock
 
I am using Centos 5.3 and I had the same problem, I solved this way...

Removed ISPCONFIG3
removed myDNS
using phpmyadmin removed all ispconfig or mydns DBs and users

then:

reinstall myDNS
reinstall ISPCONFIG3
problem solved

this steps should work on any linux distro.

hope this help

Carlos Barrera


All times are GMT +2. The time now is 01:29.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.