Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Apt-get upgrade broke MySQL
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

Apt-get upgrade broke MySQL

Just did an apt-get update && apt-get upgrade on Debian 7 and now it's saying

Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ...
[ ok ] Stopping MySQL database server: mysqld.
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

I tried dpkg-reconfigure mysql-server-5.5 but it just says /usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed

It was working fine before I upgraded, now I can't get MySQL to start at all.

Comments

  • TACServersTACServers Member
    edited November 2014

    @hostnoob - Try apt-get dist-upgrade

    Thanked by 1hostnoob
  • apt-get --reinstall install mysql-server

    Thanked by 1hostnoob
  • If the other suggestions don't work, you can also try using aptitude instead of apt-get. It often handles conflicts better than apt-get.

    Thanked by 1hostnoob
  • Check MySQL error log, fix the error, and run "apt-get -f install"

    Thanked by 1hostnoob
  • default-storage-engine = myisam

    Stick that in your mysql conf

    Thanked by 1hostnoob
  • kkrajkkkrajk Member
    edited November 2014

    rajprakash said: default-storage-engine = myisam Stick that in your mysql conf

    Mysql not installed properly in the firstplace

    Thanked by 1hostnoob
  • msg7086msg7086 Member
    edited November 2014

    @ez2uk said:
    Mysql not installed properly in the firstplace

    A missing option could be the reason to prevent starting and cause an unfinished installation.

    [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
    
    Thanked by 1hostnoob
  • said: invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server

    Thanked by 1hostnoob
  • Try to remove MySQL

    sudo apt-get remove --purge mysql-server mysql-client mysql-common
    sudo apt-get autoremove
    sudo apt-get autoclean

    Then install again

    sudo apt-get update
    sudo apt-get install mysql-server
    sudo mysql_install_db
    sudo /usr/bin/mysql_secure_installation
    Thanked by 1hostnoob
  • can you show your source.list? i had this same issue when i would do a fresh install, install dotdeb repos, then do an install from apt-get for mysql-server. Just curious.

    Thanked by 1hostnoob
  • hostnoobhostnoob Member
    edited November 2014

    thanks for the replies guys, will try some out now

    it was installed properly before and working fine. here's my sources.list

    deb http://ftp.uk.debian.org/debian stable main contrib non-free
    
    deb http://ftp.debian.org/debian/ wheezy-updates main contrib non-free
    
    deb http://security.debian.org/ wheezy/updates main contrib non-free
  • Okay I sorted it now. raj was pretty close.

    I moved my my.cnf file out of /etc/mysql/ then upgraded it, moved the cnf file back and restarted and it's working fine now :)

  • had the exact same problem last wednesday... Almost had a heart attack lol. I was actually thinking about switching to mariadb... Took the opportunity to do it and couldn't be happier

Sign In or Register to comment.