Ubuntu 16.04 Upgrade 이후 Mysql 돌지 않을 때

우분투가 16.04 로 LTS Version이 새로 릴리즈 되었습니다.

역시 바로바로 적용!!!!

그런데 mysql 이 돌지 않습니다.!!!

Setting up mysql-server-5.7 (5.7.11-0ubuntu6) ... Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.7 (--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.7; however: Package mysql-server-5.7 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured No apport report written because the error message indicates its a followup error from a previous failure. Processing triggers for systemd (229-4ubuntu4) ... Processing triggers for ureadahead (0.100.0-19) ... Errors were encountered while processing: mysql-server-5.7 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)

찾아보니 5.5, 5.6 에서 변경되는 것이 많아서 5.7 업그레이드 충돌이 일어난다고 하네요

Solution을 찾아보니 아래와 같습니다.

Back up your my.cnf file in /etc/mysql and remove it

Remove the folder /etc/mysql/mysql.conf.d/

Verify you don’t have a my.cnf file stashed somewhere else (I did in my home dir!)

Backup and remove /etc/mysql/debian.cnf files (not sure if needed, but just in case)

sudo apt purge mysql-server mysql-server-5.7 mysql-server-core-5.7

sudo apt install mysql-server

그런데 똑같네요 ..

또 다른 솔루션은 제대로 돌아가네요.

$ sudo apt-get remove — purge mysql-common mysql-client mysql-server dbconfig-mysql

$ sudo apt-get autoremove

$ sudo apt-get install mysql-server