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.

Starting MySQLCouldn't find MySQL manager or server

Discussion in 'General Discussion' started by casey, May 3, 2006.

  1. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    When upgrading to mysql5 many people who have customized their my.cnf files may find that mysql won't start. In this case, make sure that you comment out or remove the basedir config:

    [mysql.server]
    user=mysql
    #basedir=/var/lib

    Hope that saves somebody some time. ;)
     
  2. LuisMello

    LuisMello Member

    Joined:
    May 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    some problems
     
  3. richy

    richy Well-Known Member

    Joined:
    Jun 30, 2003
    Messages:
    276
    Likes Received:
    1
    Trophy Points:
    16
    Whhooo! We were getting the:
    StartingMySQL Couldn't find MySQL manager or server [FAILED]
    message after upgrading to MySQL 5 and this post fixed it! Many thanks!
     
  4. LuisMello

    LuisMello Member

    Joined:
    May 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    My problem resolved, i remove my.cnf from mysql 4.x.
     
  5. hostace

    hostace Member

    Joined:
    Dec 4, 2003
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Thank you, that helped.
     
  6. avik

    avik Member

    Joined:
    May 31, 2003
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    yes. it's working now.

    my /etc/my.cnf :

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

    [mysql.server]
    user=mysql
    basedir=/var/lib
    old-passwords = 1

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid


    i have removed parameter (basedir=/var/lib) and mysql is working now.
     
  7. Arsalan

    Arsalan Well-Known Member

    Joined:
    Jan 5, 2002
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Removing the basedir worked for us! Thanks.
     
  8. liquidcherry

    liquidcherry Well-Known Member

    Joined:
    Jan 20, 2004
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    Hey casey,

    Thx this should be a sticky:)

    Cheers,

    Frank
     
  9. neonix

    neonix Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    124
    Likes Received:
    2
    Trophy Points:
    0
    Thanks casey

    This saved me a lot of time :)
     
  10. handsonhosting

    handsonhosting Well-Known Member

    Joined:
    Feb 17, 2002
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Omaha, NE
    cPanel Access Level:
    Root Administrator
    definitly needs to be made sticky!
     
  11. DWHS.net

    DWHS.net Well-Known Member
    PartnerNOC

    Joined:
    Jul 28, 2002
    Messages:
    1,569
    Likes Received:
    6
    Trophy Points:
    38
    Location:
    LA, Costa RIca
    cPanel Access Level:
    Root Administrator
    Hmm, worked for me too. Strange
     
  12. touma

    touma Member

    Joined:
    Apr 13, 2004
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    São Paulo - Brasil
    wow... thanks! :) Almost shooting myself! hahaha
     
  13. Finley Ave

    Finley Ave Active Member

    Joined:
    Feb 28, 2004
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    San Ramon, CA
    yeah, I was just getting a loop of rope to hang myself from the closet door, but the doorknob broke off, too many twinkies. Thanks Casey!!
     
  14. mambomouth

    mambomouth Member

    Joined:
    Jul 16, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Thank you for the tips guys it the basedir for me as well.
    rhel 5 mysql 5.0.27 upgraded.

    Cheers,
    Brian
     
  15. kazey

    kazey Member

    Joined:
    Mar 30, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Upgrading to MYSQL 5 on Cpanel/WHM Server

    This is what worked for me.

    Step 1.)
    Go into your WHM > TweakSettings and select the MySQL 5 > Save it

    Step 2.)
    login as root via SSH and run /scripts/mysqlup, it will do the upgrade for you.

    Step 3.)

    Rem out the line in /etc/my.conf that was setting basedir to /var/lib. As seen below:

    user=mysql
    #basedir=/var/lib

    Step 4.)

    Create the directory "/var/run/mysqld" if it does not exist. Then chown that directory to mysql.mysql as below...

    mkdir /var/run/mysqld
    chown mysql.mysql /var/run/mysqld

    Step 5.)
    Kindly check if a socket file exists on /tmp.
    if not add one
    root@server [~]# cd /tmp
    root@server [/tmp]# ln -s /var/lib/mysql/mysql.sock .

    Step 6.)
    Start the service..

    service mysql start
     
  16. ArbuZz

    ArbuZz Active Member

    Joined:
    Mar 27, 2007
    Messages:
    33
    Likes Received:
    0
    Trophy Points:
    6
    OK, now.

    #basedir=/var/lib works, but why?

    what's the point anyway?
     
  17. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    That's for customized installs as the basedir directive instructs MySQL to look in that location for all the MySQL tools (binaries).
     
  18. sassy

    sassy Registered

    Joined:
    Sep 12, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    When i try to run this command i get permission denied

    mkdir /var/run/mysqld: permission denied

    can someone help me i am lost at the moment.


    thanking in advance



    :confused:
     
    #18 sassy, Mar 21, 2008
    Last edited: Mar 21, 2008
  19. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Are you executing the command as root?

    Does /var/run exist?
     
  20. sassy

    sassy Registered

    Joined:
    Sep 12, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I upgraded and when i try to restart mysql i get this error.


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

    I cant work out what has gone wrong so i tried to do what is mention in this thread


    @cpanelkenneth

    I run it as admin being a FREEBSD server


    /var/run : permission denied


    If someone can help me iam willing to pay to get this fixed.



    :confused:
     
Loading...

Share This Page