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.

UpGrate MySQL

Discussion in 'General Discussion' started by faison, Oct 19, 2006.

  1. faison

    faison Active Member

    Joined:
    Apr 17, 2005
    Messages:
    34
    Likes Received:
    0
    Trophy Points:
    6
    Hi there
    I Upgrated mySQL

    4.0 to 5.0

    i used a option in tweak setting

    chose MySQL 5.0
    run Software/Update Server Software

    buildapache

    then

    /scripts/perlinstaller --force Bundle::DBD::mysql


    BUT

    I got this Error


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



    How can i do?
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    if memory servers me, the problem has to do with the configuration file in the /etc folder: my.cnf
    look at that file and coment out the following:
    Code:
    [mysql.server]
    # basedir = /var/lib
    
    comment out the basedir and restart MySQL. after the upgrade from 4 to 5, it reads from the old ver., 4 my.cnf.
    If you do a search on this site on problems upgrading to MySQL 5, you should find a considerable amount of info on this topic ;)

    Mickalo
     
Loading...

Share This Page