Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this question)[http://askubuntu.com/questions/224/how-to-i-move-mysql-data-files-onto-different-partition] which I already successfully used several times but this time something went wrong and I got the error
$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
so I reinstalled mysql (several times as I kept getting that error), mainly with the following commands:
# ** uninstall: sudo su rm -r /var/lib/mysql # delete the database aptitude remove mysql-server mysql-client mysql-common apt-get autoremove apt-get autoclean # ** reinstall apt-get install mysql-server mysql-client mysql-common apt-get update
The disk is not full and I think think the problem is that at some point somehow I managed to get
/etc/apparmor.d/usr.sbin.mysqld deleted and now I have the previous problem and also
$ service mysql status mysql: unrecognized service
The disk is not full and if I reinstall mysql the file is not added. So, thanks to @AbrahamVanHelpsing I got the file from source, but the problem stills. Any ideas?
aa-status did not mention mysql but it does now that I put the file that was missing.
I can access mysql by running
sudo mysqld and then
mysql from another terminal, I still hope to register mysql in apparmor though