MySQL problem

Discussion in 'General' started by dimas, Feb 14, 2013.

  1. dimas

    dimas Member

    Hello everybody, I have a big problem on a production server (ISPConfig 3.0.4.6, Debian Squeeze 64-bit, Perfect Setup)

    I noticed that I can't create new mysql databases via ISPConfig interface. A line with a new database actually appears, but no new database is actually created - and there's nothing new in /var/lib/mysql

    I tried to log in as mysql root user via shell - and there was another nasty surprise - it said access denied (wrong credentials)!

    So something - or someone - changed my root mysql password.

    I still CAN login as other regular mysql users.

    I tried to reset the root user password by using this howto:

    http://www.howtoforge.com/reset-forgotten-mysql-root-password

    but this line

    mysqld_safe --skip-grant-tables

    doesn't start mysql, it just hangs...

    So - was the server hacked, or something just went wrong?

    Is there a way to somehow revive the server?

    I'd welcome any advice!
     
  2. till

    till Super Moderator

  3. dimas

    dimas Member

    Dear Till, thank you, but this is what is happening:

    root@server2:~# /etc/init.d/mysql stop
    Stopping MySQL database server: mysqld.
    root@server2:~# mysqld_safe –skip-grant-tables &
    [1] 5790
    root@server2:~# 130214 19:07:47 mysqld_safe Logging to syslog.
    130214 19:07:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    130214 19:07:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

    - and no prompt appears (I waited a long time)

    If I try to input the next command from another shell window, I get:

    root@server2:~# mysql -u root mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
     
  4. till

    till Super Moderator

    Thats ok, the mysql program has no prompt. It just starts and gets to the background as ID [1] 5790.

     

Share This Page