Day: June 12, 2023

sudo su
 
cp -R /var/lib/mysql /home/work/
chown -R mysql:mysql /home/work/mysql
 
vi /etc/mysql/mysql.conf.d/mysqld.cnf
	socket  = /home/work/mysql/mysqld.sock
	datadir = /home/work/mysql
 
systemctl start mysql
cat /var/log/mysql/error.log
	mysqld: File './binlog.index' not found (OS errno 13 - Permission denied)
 
vi /etc/apparmor.d/usr.sbin.mysqld
	/usr/sbin/mysqld {
		/home/work/mysql/ r,
		/home/work/mysql/** rwk,
		...
 
systemctl restart apparmor
systemctl start mysql