The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 5 - Connect to server at 'localhost' failed

Discussion in 'General Discussion' started by smarttart62, Sep 27, 2007.

  1. smarttart62

    smarttart62 Registered

    Aug 13, 2007
    Likes Received:
    Trophy Points:
    I just upgraded to MySQL 5, thought it was a good move for my hosting service... Wrong.

    I now get the error:
    Everytime i try to get WHM to reset MySQL (I also get "Starting MySQLCouldn't find MySQL manager or server " in SSH when trying manually).

    I've tried everything I can think of, and have gone through numerous sites online to no avail.

    Can someone help me please? I really need to get this up faster then cPanel's email support, but don't want to pay the telephone support premium.
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Apr 7, 2006
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    Assuming you are on an RPM using system, what does:

    rpm -qa | grep -i mysql


    Also, what does the mount command return for the various tmp mounts. For example, on a sample system:

    root@mundane [/home34y69da/tramel/.cpanel]# mount
    /dev/sda1 on / type ext3 (rw,usrquota)
    none on /proc type proc (rw)
    none on /sys type sysfs (rw)
    none on /dev/pts type devpts (rw,gid=5,mode=620)
    usbfs on /proc/bus/usb type usbfs (rw)
    none on /dev/shm type tmpfs (rw)
    /dev/sda4 on /images type ext3 (rw,usrquota)
    /dev/sda3 on /tmp type ext3 (rw,noexec,nosuid)
    /dev/sdb1 on /home34y69da type ext3 (rw,usrquota)
    none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
    /tmp on /var/tmp type none (rw,noexec,nosuid,bind)
    sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

    Is there anything in /etc/my.cnf that pertains to the sock file?

    Does /var/lib/mysql still exist?

    Does the mysql user exist on the system?

    Are there any specific errors in the /var/lib/mysql/systemname.err log?

Share This Page