Results 1 to 1 of 1

Thread: [FAIL] Stopping MySQL database server: mysqld failed!

  1. #1
    Assadministrator kung foo man's Avatar
    Join Date
    Jun 2012
    Location
    trailerpark
    Posts
    2,011
    Thanks
    2,102
    Thanked 1,084 Times in 753 Posts

    [FAIL] Stopping MySQL database server: mysqld failed!

    Hey all,

    in Debian 7.0 Wheezy they added special permissions for server restarting. Not knowing this, I just overwrite the MySQL-databases with my backed up ones. After that, I couldn't restart the server anymore.

    To fix that, you need to grant rights on the database "mysql" for "debian-sys-maint". The password is written in /etc/mysql/debian.cnf

    Code:
    /etc/init.d/mysql restart
    [FAIL] Stopping MySQL database server: mysqld failed!
    [ ok ] Starting MySQL database server: mysqld already running.
    Code:
    GRANT ALL PRIVILEGES ON mysql TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'the maintainer password' WITH GRANT OPTION;
    Now you should be able to restart the server with /etc/init.d/mysql restart, I didn't need "FLUSH PRIVILEGES".

    Regards,
    kung foo man
    timescale 0.01

  2. The Following 2 Users Say Thank You to kung foo man For This Useful Post:

    Earliboy (3rd June 2013),STAUFFi (14th May 2013)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •