Permanently modify /etc/systemd/system/mysql.service

[gersonfs]

Hello

I need to permanently modify /etc/systemd/system/mysql.service, more precisely the settings ProtectSystem = false and ProtectHome = false
I changed this file and executed systemctl daemon-reload
But I missed the changes tonight, I believe it's due to an update. How do I make these changes permanent?

 

[cPanelMichael]

Hello,

You should be able to add a separate configuration file. EX:

touch /etc/systemd/system/mysqld.service.d/protect.conf
chmod 0600 /etc/systemd/system/mysqld.service.d/protect.conf

# cat /etc/systemd/system/mysqld.service.d/protect.conf
[Service]
ProtectHome=false
ProtectSystem=false

Let us know if that helps.

Thank you.

 

[gersonfs]

Thanks, it should help!

 

[gersonfs]

It only worked after put this file on /etc/systemd/system/mariadb.service.d

 

[cPanelMichael]

It only worked after put this file on /etc/systemd/system/mariadb.service.d

Are you using MySQL or MariaDB on this system?

Thank you.

 

[gersonfs]

MariaDB. Sorry, I forgot to report it.

 

[cPanelMichael]

Hello,

Yes, if you are using MariaDB, then /etc/systemd/system/mariadb.service.d/ is the correct location to add the include file.

Thank you.