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.

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:
    1
    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,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    /tmp should never ever be chmod 777, it needs to be 1777
     
  3. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    272
    Likes Received:
    0
    Trophy Points:
    16
    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:
    16
    Like Chirpy said, make sure it is : 1777

    lamp
     
  5. jax113

    jax113 Registered

    Joined:
    Jul 10, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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:
    272
    Likes Received:
    0
    Trophy Points:
    16
    Try:

    /scripts/fixmysql

    /scripts/mysqlup
     
  7. jax113

    jax113 Registered

    Joined:
    Jul 10, 2006
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
  9. katmai

    katmai Well-Known Member

    Joined:
    Mar 13, 2006
    Messages:
    526
    Likes Received:
    0
    Trophy Points:
    16
    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
     
Loading...

Share This Page