MySQL service won't start

Help
2011-05-22
2013-05-22
  • dennisonline
    dennisonline
    2011-05-22

    Hello,

    I have installed MySQL with Webmin and saw a lot of (many) tasks sroll in the browers. After finish it seems to be work.
    After import a dbase and restart the service won't start anymore…

    from the SYSLOG:

    May 22 21:22:42 parakalo-nas mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
    May 22 21:22:42 parakalo-nas mysqld: 110522 21:22:42 [Note] Plugin 'FEDERATED' is disabled.
    May 22 21:22:42 parakalo-nas mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
    May 22 21:22:42 parakalo-nas mysqld: 110522 21:22:42 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    May 22 21:22:43 parakalo-nas mysqld: 110522 21:22:43  InnoDB: Started; log sequence number 0 44233
    May 22 21:22:43 parakalo-nas mysqld: 110522 21:22:43 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    May 22 21:22:43 parakalo-nas mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
    May 22 21:22:57 parakalo-nas /etc/init.d/mysql[19433]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
    May 22 21:22:57 parakalo-nas /etc/init.d/mysql[19433]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
    May 22 21:22:57 parakalo-nas /etc/init.d/mysql[19433]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    May 22 21:22:57 parakalo-nas /etc/init.d/mysql[19433]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
    May 22 21:22:57 parakalo-nas /etc/init.d/mysql[19433]:
    

    I have remove it ( apt-get remove mysql-server ) and install again ( apt-get install mysql-server ) but no result.

    Who can help me?

    Dennis