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!

cpanel 11 upgrade mysql 4.1 -> 5 error

Discussion in 'General Discussion' started by manuxer, Jul 17, 2007.

  1. manuxer

    manuxer Active Member

    Joined:
    Aug 16, 2006
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    156
    I've upgraded from mysql 4.1 to 5.
    Now when i restart the mysql server from cpanel i've got the 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").

    or in console:

    service mysql restart
    MySQL manager or server PID file could not be found! [FAILED]
    Starting MySQLCouldn't find MySQL manager or server [FAILED]

    i know that must be a fix. i removed /var/lib/mysq and did a /script/mysqlup but with no result.
    Please give me a hint.
    thanks
     
  2. manuxer

    manuxer Active Member

    Joined:
    Aug 16, 2006
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    156
    I partialy solve the problem, now the mysql server is starting, but i got the error:

    /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' mysql has failed, please contact the sysadmin (result was "mysql has failed").

    it's about mysql root password.
    Any hints?
     
  3. CoreISP.net

    CoreISP.net Active Member

    Joined:
    May 25, 2006
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    DataCenter Provider
    You can set the root password for mySQL in WHM in the mySQL section:
    "Change mySQL root password"
     
  4. manuxer

    manuxer Active Member

    Joined:
    Aug 16, 2006
    Messages:
    30
    Likes Received:
    0
    Trophy Points:
    156
    Well, i've solved the problem.
    I advise anyone upgrading to mysql 5 to be very careful.
     
  5. CoreISP.net

    CoreISP.net Active Member

    Joined:
    May 25, 2006
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    DataCenter Provider
    I have had no problems on multiple servers with upgrading the mySQL version on request...
     
  6. Erik.B.

    Erik.B. Registered

    Joined:
    Jul 29, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    Would you be so kind to share your solution with us?
    We're experiencing the same issue while upgrading MySQL 4.1 to MySQL 5.0 through 'Tweak Settings' ...Even worse: the whole MySQL gone fishin' (not installed anymore...). Currently, we're reinstalling it from ports (FreeBSD server) and hopefully it'll work again after that..
     
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