1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

mysqld can't start

Discussion in 'Plesk for Linux - 8.x and Older' started by ittec, Jun 15, 2007.

  1. ittec

    ittec Guest

    0
     
    Hi all

    this is my first post, so hello to all members.

    Im admin of a "old" Plesk. I think it 7.5 version, but im not sure. I have access to server by SSH and not by web because MYSQL its off.

    When i try to reboot MYSQL in SSH console, the system returns:

    Code:
    Stopping MySQL:                                    
    
    [COLOR=red][FAILED][/COLOR]
    
    Timeout error occurred trying to start MySQL Daemon.
    If a try to enter by web i see this:

    Code:
    ERROR: Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 0:
    
    /usr/local/psa/admin/auto_prepend/auth.php3:81 psaerror(string "Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")
    
    Perhaps the error is by MYSQL setup, but im not sure. I rembember that i modified my.cnf few days ago

    MYSQL setup:
    Code:
    
    [mysqld]
    safe-show-database
    innodb_data_file_path=ibdata1:10M:autoextend
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    max_connections=400
    max_connect_errors=999999
    
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    Can anyone help me? Im looking for mysql error log, but i dont' find it.

    Thanks.
     
  2. ittec

    ittec Guest

    0
     
    Well,

    finally i found mysql log and saw error. Alls works now.

    InnoDb setup in my.cnf was the problem.

    Thanks.
     
Loading...