If you install MySQL using an RPM or Debian package server, startup and shutdown is managed by systemd. On platforms for which the systemd support for MySQL is installed, mysqld_safe, mysqld_multi, and mysqld_multi.server are not installed. MySQL server startup and shutdown is managed by systemd using the systemctl command. You need to configure systemd as follows.

1. Create a localized systemd configuration file:

shell> sudo mkdir -pv /etc/systemd/system/mysqld.service.d

2. Create/open the conf file:

shell> sudo vi /etc/systemd/system/mysqld.service.d/override.conf

3. Enter the following:

[Service]
LimitNOFILE=max_open_files (ex: 102400)
PIDFile=/path/to/pid/file (ex: /var/lib/mysql/mysql.pid)
Nice=nice_level (ex: -10)
Environment="LD_PRELOAD=/path/to/malloc/library" Environment="TZ=time_zone_setting"

4. Reload systemd:

shell> sudo systemctl daemon-reload

5. For temporary changes, you can reload without editing the conf file:

shell> sudo systemctl set-environment MYSQLD_OPTS="--general_log=1"
or unset using
shell> sudo systemctl unset-environment MYSQLD_OPTS

6. After modifying the systemd environment, restart the server to make the changes effective.
   Enable mysql.serviceshell> sudo systemctl, and enable mysql.service:

shell> sudo systemctl unmask mysql.service

7. Restart mysql:
   On RPM platforms:

shell> sudo systemctl restart mysqld

On Debian platforms:

shell> sudo systemctl restart mysql