Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

help pleas

Discussion in 'General Discussion' started by jax113, Jul 10, 2006.

  1. jax113

    jax113 Registered

    Joined:
    Jul 10, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    hi i have upgrade mysql to 5.0.1 but now when i make Restart Services to SQL Server (MySQL) it show to me this error messeage

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

    this error in WHM
    in the Cpanel it show me this error

    [an error occurred while processing this directive]

    [an error occurred while processing this directive] an error occurred while processing this directive

    and in MySQL Databases it show :Sorry, your Cpanel Config file is missing your dns info. / unlimited

    what should i do to fix it
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,460
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    /tmp should never ever be chmod 777, it needs to be 1777
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    282
    Likes Received:
    2
    Trophy Points:
    168
    1) check /tmp is chmod 1777 (CORRECTED)

    2) check /etc/my.cnf exist and it is empty

    3) try to startup mySQL service manually , I'm not sure what is the startup parameters in linux, but on FreeBSD you can start from /etc/init.d/mysql start

    You can also try manual start from /usr/local/bin/mysqld_safe --user=mysql > /dev/null 2>&1 &

    Tamouh
     
    #3 hicom, Jul 10, 2006
    Last edited: Jul 10, 2006
  4. lamp

    lamp Well-Known Member

    Joined:
    Dec 22, 2003
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    166
    Like Chirpy said, make sure it is : 1777

    lamp
     
  5. jax113

    jax113 Registered

    Joined:
    Jul 10, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    i made this command
    chmod 1777 /tmp

    and it take it ... my file "my.cnf"

    [mysqld]
    datadir=/var/lib/mysql
    socket=/tmp/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    [mysql.server]
    user=mysql
    basedir=/var/lib
    old-passwords = 1

    when i tride to make this command
    /etc/init.d/mysql start
    it show to me this error

    Starting MySQLCouldn't find MySQL manager or server [FAILED]

    ???? what can i do now
     
  6. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    282
    Likes Received:
    2
    Trophy Points:
    168
    Try:

    /scripts/fixmysql

    /scripts/mysqlup
     
  7. jax113

    jax113 Registered

    Joined:
    Jul 10, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    i Try:

    /scripts/fixmysql

    /scripts/mysqlup

    but it still does not work ??:rolleyes:
     
  8. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,051
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Earth
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    532
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Brno, Czech Republic
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    #old_passwords=1

    [mysql.server]
    user=mysql
    # basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid



    this is my mysql 5 config. check the line with basedir. mysql 5 is smarter and knows how to do it
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice