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.

MySQL not starting

Discussion in 'General Discussion' started by fdnet, Nov 8, 2006.

  1. fdnet

    fdnet Member

    Joined:
    May 5, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    There is prob a post somewhere on this forum somewhere but i cannot find it!

    I just upgraded mysql from 4.1 to 5.0 (Brave step!) and now i cannot get the server to boot mysql up. I've tried all sorts but most of what I have found is for if MySQL is running...

    Starting MySQL Couldn't find MySQL manager or server [FAILED]
    ...
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    Unable to reset root MySQL password. at /scripts/securemysql line 150.
    Install Complete

    (I added the Install Complete at the end for entertainment value!)

    Just to give you a run down of what i have tried in desperations already:

    cd /var/lib/mysql
    touch mysql.sock
    chown mysql:mysql mysql.sock
    chmod 1777 mysql.sock
    ln -s /var/lib/mysql/mysql.sock /tmp
    chmod 1777 /tmp
    /scripts/mysqlup --force (extract above of what it is saying)
    /etc/rc.d/init.d/mysql restart
    Code:
    MySQL manager or server PID file could not be found!       [FAILED]
    Starting MySQLCouldn't find MySQL manager or server        [FAILED]
    
    Im crying now so please help!!! :'(
     
  2. fdnet

    fdnet Member

    Joined:
    May 5, 2004
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    I'm now crying with joy :D

    i was playing around and did:

    su mysql
    /usr/sbin/mysqld

    *****

    and that seemed to do the trick.
     
  3. sawbuck

    sawbuck Well-Known Member

    Joined:
    Jan 18, 2004
    Messages:
    1,367
    Likes Received:
    5
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  4. ZeusChicago

    ZeusChicago Active Member

    Joined:
    Oct 9, 2005
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    The above two steps got me throught the 4.x to 5.x mySql upgrade.

    Thank god for Search and the Forums!

    Zeus
     
Loading...

Share This Page