and BTW the "--pid-file=/dev/null" has a damned good reason because you don't need to care about subfolders below /run to get re-created with corerct permissions at reboot while a restriucted user can't create folders and files there and run is tmpfs aka memory since mariadb is a single-process multi-threadded service and systemd can watch it perfectly without handholing no pid-file stuff is needed at all Am 15.05.2018 um 12:34 schrieb Reindl Harald:
Am 15.05.2018 um 12:22 schrieb Muhammad Bashir Al-Noimi:
On 05/15/2018 01:12 PM, Reindl Harald wrote:
so it works and " error: 'Access denied for user 'root'@'localhost' (using password: YES)'" is what it is
are you aware that 'root' on unix-socket (localhost) is not the same than 'root' over TCP (127.0.0.1) beause you have a host column?
also make sure you did run 'mysql_upgrade' and if nothing else helps google for "mysql skip grant" but be aware that this allows *any* user with *any* password until removed from the config, but so you can bypass logins and fix things properly Worked but still important issue with systemctl. I wonder what's wrong with mariadb.service https://gist.github.com/mbnoimi/5920301ff79dcb88aab3ef7fa459733e
can you please stop posting links left and right?
* that's all plaintext * post it deirectly * look in the errorlog * post systemctl outputs (also for systemctl status)
*what is that issue*
likely your unit is missing the [Install]-section at the bottom which is the reason you can't enable it - sorry but i hate it to guess
[Install] WantedBy=multi-user.target _________________________
i simply stripped down the unit to the relevant parts for get rid of mysqld_safe because i don't think that you understand most implications of the full unit i use and don't want a endless thread _________________________
[root@buildserver:~]$ cat /usr/lib/systemd/system/mysqld.service [Unit] Description=MariaDB Database Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service dbmail-timsieved.service
[Service] Type=notify KillMode=process KillSignal=SIGTERM SendSIGKILL=no
User=mysql Group=mysql
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/dev/null Environment="LANG=en_GB.UTF-8" Restart=always RestartSec=1 TimeoutSec=300 LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 TasksMax=2048
AmbientCapabilities=CAP_IPC_LOCK CAP_SYS_NICE CapabilityBoundingSet=CAP_IPC_LOCK CAP_SYS_NICE MemoryDenyWriteExecute=yes NoNewPrivileges=yes PrivateDevices=yes PrivateTmp=yes ProtectControlGroups=yes ProtectKernelModules=yes ProtectKernelTunables=yes RestrictAddressFamilies=AF_UNIX AF_LOCAL AF_INET AF_INET6 SystemCallArchitectures=x86-64 SystemCallFilter=~@clock @cpu-emulation @debug @keyring @module @mount @obsolete @raw-io @reboot @swap acct modify_ldt add_key adjtimex clock_adjtime delete_module fanotify_init finit_module get_mempolicy init_module kcmp kexec_load keyctl lookup_dcookie mbind mount open_by_handle_at perf_event_open pivot_root process_vm_readv process_vm_writev ptrace request_key set_mempolicy swapoff swapon umount2 uselib vmsplice
ReadOnlyDirectories=/etc ReadOnlyDirectories=/usr ReadOnlyDirectories=/var/lib ReadWriteDirectories=/var/lib/mysql
InaccessibleDirectories=-/boot InaccessibleDirectories=-/home InaccessibleDirectories=-/root InaccessibleDirectories=-/media InaccessibleDirectories=-/etc/httpd InaccessibleDirectories=-/etc/postfix InaccessibleDirectories=-/etc/ssh InaccessibleDirectories=-/usr/local/scripts InaccessibleDirectories=-/var/lib/dbus InaccessibleDirectories=-/var/lib/dnf InaccessibleDirectories=-/var/lib/rpm InaccessibleDirectories=-/var/lib/systemd InaccessibleDirectories=-/var/spool InaccessibleDirectories=-/run/dbus InaccessibleDirectories=-/run/lock InaccessibleDirectories=-/run/mount InaccessibleDirectories=-/run/systemd/generator InaccessibleDirectories=-/run/systemd/system InaccessibleDirectories=-/run/systemd/users InaccessibleDirectories=-/run/udev InaccessibleDirectories=-/run/user
[Install] WantedBy=multi-user.target