Sunday, May 28, 2023
 Popular · Latest · Hot · Upcoming
rated 0 times [  0] [ 0]  / answers: 1 / hits: 9085  / 9 Months ago, fri, september 16, 2022, 7:38:51

Mysql was working, then I tried to move the MySql database directory as in this question 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 re-installed 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.

Another edit

I can access mysql by running sudo mysqld and then mysql from another terminal, I still hope to register mysql in apparmor though

More From » mysql


You need to add the new MySQL location to apparmor alias.

To add it, simply type

sudo nano /etc/apparmor.d/tunables/alias

And add this to the end of the file

/your/new/data/dir -> /var/lib/mysql

Note: you may see the ubuntu buit-in manual in the file

And type

sudo invoke-rc.d apparmor reload

Then it should work

Or a simpler solution

Remove AppAmor

sudo apt-get purge apparmor

[#33121] Sunday, September 18, 2022, 9 Months  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 400
Total Questions: 103
Total Answers: 98

Location: Netherlands
Member since Mon, Jun 22, 2020
3 Years ago