Howdy, Stranger!

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

Sign In Register

Quick Links


BMail.ag - Secure Email Service
Server.net
CPLicense.net
VPS Server
Buy VPN
Vultr
VMs for AI
HostDare
ReliableSite White-Label Dedicated Hosting for Resellers
K.N Cloud — High-Performance KVM VPS in Miami,Frankfurt and Amsterdam
InterServer VPS
BMail.ag - Secure Email Service
Best VPN
High-Performance Bare Metal Server Solutions
Karvl.com
Server Mania Cloud Hosting
DataWagon Hosting
AlphaVPS Hosting
Evoxt.com
Clouvider
VPS Hosting with NVMe
Residential IPs in the US & 4G Mobile Proxies in EU & US with Unlimited Bandwidth
ReliableSite White-Label Dedicated Hosting for Resellers
Rabisu - Hosting Solutions
CloudLinux
JUST.HOSTING AI-READY VPS
Servury - Anonymous & Privacy-focused VPS Hosting
Animated Silicon Kiwi cloud ad featuring VPS from $4.90/month, 100 GB S3 storage from $1.49/month, Kiwi Apps from $12/month and cloud backup from $3/month

Categories

In this Discussion

Home › General
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

hostnoobhostnoob Veteran
in General

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
  • kkrajkkkrajk Member

    apt-get --reinstall install mysql-server

    Thanked by 1hostnoob
  • colmcolm Member

    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
  • ProfforgProfforg Member

    Check MySQL error log, fix the error, and run "apt-get -f install"

    Thanked by 1hostnoob
  • Lm85H4gFkh3wk3Lm85H4gFkh3wk3 Member

    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
  • kkrajkkkrajk Member

    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
  • comXyzcomXyz Member

    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
  • doughnetdoughnet Member

    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 Veteran
    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
  • hostnoobhostnoob Veteran

    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 :)

  • FutureFuture Member

    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.