{"id":561,"date":"2009-11-12T17:21:06","date_gmt":"2009-11-12T05:21:06","guid":{"rendered":"http:\/\/p-s.co.nz\/wordpress\/?p=561"},"modified":"2009-11-29T07:52:58","modified_gmt":"2009-11-28T19:52:58","slug":"karmic-mysql-problem-fixed","status":"publish","type":"post","link":"https:\/\/p-s.co.nz\/wordpress\/karmic-mysql-problem-fixed\/","title":{"rendered":"Karmic MySQL Server Problem Fixed"},"content":{"rendered":"

The Karmic upgrade went really well but MySQL server seemed to die along the way. A temporary solution that worked for me was found here – http:\/\/ubuntuforums.org\/showthread.php?t=1040786<\/a>.<\/p>\n

sudo apt-get remove --purge mysql-server-5.1
\nsudo apt-get autoremove
\nsudo rm -rf \/etc\/mysql
\nsudo apt-get install mysql-server-5.1<\/code><\/p>\n

[update] This solution doesn’t persist after reboot (at present). Still useful if I need to test MySQL but not a proper answer.
\n[update] running
\nsudo \/etc\/init.d\/mysql start
\ndoes the trick. Not sure why it isn’t happening automatically on startup.
\n[SOLUTION]
\nThe mysql file was in \/etc\/rc3\/, rc4, and rc5, but not rc2. Why? No idea at all. Anyway, a quick gksu nautilus and copying S19mysql (yours may have a different number) and pasting it from rc3 into rc2 later, then a reboot to be sure. Working as needed. NB a prefix of K means deactivate.<\/p>\n

To see if mysql is running:<\/p>\n

ps -ef | grep mysql<\/p>\n

a single line response (your mysql client?) is not a good sign.<\/p>\n

Here is on thread of interest: http:\/\/ubuntuforums.org\/showthread.php?p=8320705<\/a><\/p>\n

Here are the main resources I found useful:<\/p>\n

http:\/\/brainwreckedtech.wordpress.com\/2008\/04\/25\/ubuntu-804-bug-with-mysql-and-apparmor\/<\/a>
\nhttp:\/\/case.oncle-tom.net\/2008\/05\/04\/modifier-emplacement-donnees-serveur-mysql\/<\/a>
\nhttp:\/\/www.hobbes.ch\/2009\/11\/mysql-stopped-working-after-update\/<\/a>
\nhttp:\/\/ubuntuforums.org\/archive\/index.php\/t-1305921.html<\/a>
\nhttp:\/\/ubuntuforums.org\/showthread.php?t=1322070<\/a>
\nhttp:\/\/bugs.mysql.com\/bug.php?id=47195<\/a>
\nhttp:\/\/www.mail-archive.com\/ubuntu-server-bugs@lists.ubuntu.com\/msg16084.html<\/a>
\nNB My AppArmor mask denied etc didn’t affect the working of the system so was a bit of a side-track in my case. Mainly affects you if you don’t use standard path locations.
\nhttp:\/\/en.opensuse.org\/AppArmor_Geeks<\/a>
\nhttp:\/\/www.vanimpe.eu\/blog\/2009\/01\/13\/requested_mask-denied_mask-errors-on-ubuntu-with-mysql\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

The Karmic upgrade went really well but MySQL server seemed to die along the way. A temporary solution that worked for me was found here – http:\/\/ubuntuforums.org\/showthread.php?t=1040786. sudo apt-get remove –purge mysql-server-5.1 sudo apt-get autoremove sudo rm -rf \/etc\/mysql sudo … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,6],"tags":[],"class_list":["post-561","post","type-post","status-publish","format-standard","hentry","category-mysql","category-ubuntu"],"_links":{"self":[{"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/posts\/561"}],"collection":[{"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/comments?post=561"}],"version-history":[{"count":7,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/posts\/561\/revisions"}],"predecessor-version":[{"id":563,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/posts\/561\/revisions\/563"}],"wp:attachment":[{"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/media?parent=561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/categories?post=561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/p-s.co.nz\/wordpress\/wp-json\/wp\/v2\/tags?post=561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}