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.

[urgent]mysql doesnt work anymore

Discussion in 'General Discussion' started by ChemicalWH, Jun 22, 2004.

  1. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    hey,

    4 hours ago mysql stopped working, i can't connect anymore
    eximstats also failed
    when i try to run it in ssh: (/usr/local/cpanel/bin/eximstats) it gives the following error:

    DBI connect('eximstats:localhost','eximstats',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/cpanel/bin/eximstats line 258
    Can't Connect at /usr/local/cpanel/bin/eximstats line 261.


    also the root can't seem to login anymore,

    i tried a lot of stuff for 3,5 hours already.. without success

    anyone any ideas ?
     
  2. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    ok.. me and some other smart guy tried EVERYTHING we could possible find or think off
    it seems like the whole thing is just fucked !

    so i'll probably let some people re-image/install the whole server tomorrow and put the backups from this morning back after some software updates...

    if anyone thinks this is a bad idea and has a good solution.. feel free to post
     
  3. easyhoster1

    easyhoster1 Well-Known Member

    Joined:
    Sep 25, 2003
    Messages:
    659
    Likes Received:
    0
    Trophy Points:
    16
    First, look at the following error.

    "Can't connect to local MySQL server through socket'/var/lib/mysql/mysql.sock'"

    Is the mysql.sock in the following location?

    /var/lib/mysql

    If it is, looks like your exim mail server is down. Try running from root

    /scripts/exim4

    Thanks
     
  4. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    nope..
    that's not it..

    eximstats gives this error now:

    DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at /usr/local/cpanel/bin/eximstats line 258
    Can't Connect at /usr/local/cpanel/bin/eximstats line 261.
     
  5. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    have you tried restarting MySQL ?? Are you getting any errors when you attempt to restart MySQL ??

    If MySQL is totally gone, you may just need to reinstall.. :)

    Mickalo
     
  6. ChemicalWH

    ChemicalWH Active Member

    Joined:
    Mar 4, 2004
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    mysql can be started.. yet it wont work :-/
    can't connect

    it looks like the complete user table is fucked..

    stupid question.. how can i reinstall mysql in cpanel?
     
  7. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    well you could go to MySQL website and get the RPM's for your server, IE . *.i386.rpm. Check to see which ones you have installed at the shell prompt by
    Code:
    rpm -qa | grep MySQL
    
    this should display what's installed and just remove them and reinstall or do an update: rpm -Uvh MySQL.....i386.rpm for each of the RPM's needed.

    Also, there is a script in the /scripts folder called fixmysql which appears to reinstall MySQL. I've never used it before, but it maybe worth checking out too :)


    Mickalo
     
    #7 mickalo, Jun 22, 2004
    Last edited: Jun 22, 2004
Loading...
Similar Threads - [urgent]mysql doesnt anymore
  1. willemr90
    Replies:
    4
    Views:
    432

Share This Page