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!

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:
    156
    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:
    778
    Likes Received:
    4
    Trophy Points:
    318
    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
     
    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