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.

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:
    6
    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:
    6
    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:
    6
    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:
    6
    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:
    6
    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:
    1
    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